|
so when do we get an ELSE clause on that?
Message Signature
(Click to edit ->)
|
|
|
|
|
I second this, to let us make it finally clear:
DROP TABLE IF EXISTS SomeSchema.SomeTable ELSE DO NOT DROP TABLE SomeSchema.SomeTable
It does not solve my Problem, but it answers my question
modified 19-Jan-21 21:04pm.
|
|
|
|
|
Nah, you're missing the point:
DROP TABLE IF EXISTS SomeSchema.SomeTable
ELSE CREATE TABLE SomeSchema.SomeTable(...)
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I don't recall ever needing something like that. The more usual requirement would be to drop the table if it exists, and then always create it.
Which is basically a sticking-plaster for the fact that CREATE OR ALTER TABLE doesn't exist.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I'm thinking of recommending it as a global boolean in QA to see how many times it comes up in code samples over the next few years...
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
DROP TABLE IF EXISTS SomeSchema.SomeTable
ELSE DROP SCHEMA SomeSchema; # clearly schema in worse shape then we were told, start over time
...
# or maybe they chose the wrong database??? ooooops
SELECT "Time to run away";
Message Signature
(Click to edit ->)
|
|
|
|
|
Like all the new features, it's nice when you can dictate the db server version. Don't forget about the compatibility level setting of the database as I found out last month!
Now, if they could just get the query designer to remember the layout (x,y) of objects when I'm working on a query....every time, scroll down, drag tables/views up where I can see them all, and reposition so it makes sense...run query, if anything is wrong, repeat. Also, if it could remember it's last window state/position/screen that would convince me to start using newer versions of SSMS.
For me, SSMS 2016 fails with some MEF error every other time I need to use it, so I still do most work with 2014. I have 2017 which is OK but still slower to start than 2014. I really only use it to import Azure dbs.
"Go forth into the source" - Neal Morse
|
|
|
|
|
My only question is, why are you using a CTP of SQL 2016? It's already got 2 service packs, and the latest one's already at its fifth cumulative update.
|
|
|
|
|
I'm actually using CU3, it was CTP3 that introduced this feature.
Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain
|
|
|
|
|
Take a stroll for each morning letter you delay! (11)
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Perambulate ?
For each = per
morning = am
letter = b
you = u
delay = late
We can’t stop here, this is bat country - Hunter S Thompson RIP
modified 11-Feb-19 5:20am.
|
|
|
|
|
You are up tomorrow, but care to explain for the others?
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Yep! That's the solution I started with!
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Strange that
We can’t stop here, this is bat country - Hunter S Thompson RIP
|
|
|
|
|
|
I shared a google spreadsheet link to my boss.
Within a minute, I saw someone logging into the sheet. (Google Spreadsheet notifies this)
I hovered over the incoming user icon.. it says "Anonymous buffalo"
I had a burst of laughter, for a moment.
Guess it's better if google picks non-derogatory animal names for such labeling/avatar purpose.
I understand it's purely subjective & a cultural thing, but still companies should give a bit of importance to local culture/sentiments.
|
|
|
|
|
I'd be more worried that they'd used their 3TB of personal data about your boss to have come up with the "buffalo" profile (there's probably a page explaining what the profile names mean).
That's one of the attributes of google: the more cutesy and buddy-buddy they behave, the more devious their real objectives.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Mark_Wallace wrote: I'd be more worried that they'd used their 3TB of personal data about your boss to have come up with the "buffalo" profile
|
|
|
|
|
|
29. Force file to call (5)
|
|
|
|
|
DRIVE?
Don't have a reasoning though.
[EDIT]
Haven;t been in the Lounge for a while; what' a "mini CCC"? What's 18 (in the subject) and 29 (in the clue)? Is it still winner-stays-on?
You have just been Sharapova'd.
|
|
|
|
|
Agent__007 wrote: Haven;t been in the Lounge for a while; what' a "mini CCC"? What's 18 (in the subject) and 29 (in the clue)? Is it still winner-stays-on?
I put a Mini CCCs write up on my profile page[^] - the numbering is, well, numbering.
And nope, not DRIVE.
|
|
|
|
|
Not a programming question but a Windows 10 and an MSI not talking to each other.
Got a work customer that is sitting in a Domain with AD Servers sitting on Windows Server 2012 R2. Their computers are all on 1803 and we haven't allowed the rollout of 1809 after Octobers clusterelephant.
They have a program update from Corporate Headquarters I need to install but it is complaining that .NET 4.7 is required. 1803 comes with 4.7.2 included, I have confirmed it is there via Registry and also Windows Components.
The MSI log created gave me nothing useful to go on.
Anyone got a pointer or a clue bat for me?
<EDIT>
Forgot to add this link in How a Windows 10 Update Might Have Broken Your .NET App[^]
</EDIT>
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash One Fine Saturday. 24/04/2004
modified 10-Feb-19 20:42pm.
|
|
|
|
|
Which installer are they using?
|
|
|
|
|
Jörgen Andersson wrote: Which installer are they using?
Thanks for the help Jorgen, I don't know if I am answering your question or looking more stupid than usual.
Properties of the installation file give me the following -
Tags Installer,MSI,Database;
Comments MODPAK, 2018.10.19, WiX Toolset
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash One Fine Saturday. 24/04/2004
|
|
|
|