Viewing 15 posts - 31 through 45 (of 129 total)
Ravi-339369 (4/22/2010)
Query...does the Insert work on SQL 2008 if the db was created in an earlier version?
I can't exactly answer your question because I don't have a copy of SQL...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
April 22, 2010 at 10:17 am
jim.tinney (4/22/2010)
I chose 0, because it did not error on select, it errored on insert. and the select returns rightly, 0 rows.
That's not quite true. If you considered the...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
April 22, 2010 at 10:08 am
To be fair, even if you saw the "Possible Error" in the INSERT (if you didn't know this was a SQL 2008 feature, like me) or if you ran it...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
April 22, 2010 at 6:06 am
Hah, should have known Hugo would come explain everything properly - ignore my posts, concentrate on his 🙂
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
April 13, 2010 at 1:19 am
BrainDonor (4/13/2010)
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
April 13, 2010 at 1:17 am
Sorry, but within the context of Microsoft terminology, this is simply wrong.
Within the context of SQL Server documentation, "UNKNOWN" (all uppercase) is used exclusively as a Boolean result in SQL...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
April 13, 2010 at 1:10 am
While the intent of the question is clear, there is currently some question as to the accuracy of the selected answer:
http://www.schneier.com/blog/archives/2009/07/another_new_aes.html
(I got the answer "right", not looking for my point...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
March 29, 2010 at 1:26 am
Hmm, I was more bothered by the fact that NOT IN() is assumed to NOT be SARGable... In SQL 2000 this was always true when there was more than one...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
February 26, 2010 at 2:00 am
Registry Access. Haven't figured out an efficient and sensible way to do it in SQL Server 2005 without using the CLR.
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
December 11, 2009 at 6:04 am
vkirkpat (12/2/2009)
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
December 2, 2009 at 6:17 am
A trickier variation could be the same question, without the "Insert" statement.
Even though there are no rows being updated in that variant, the trigger still finds that the column was...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
December 2, 2009 at 2:29 am
To each his own, I guess!
To me, your "fix" makes it even harder to read (keeping a joined table on the same line as the first table? eek!) - but...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
September 30, 2009 at 3:35 pm
mohd.nizamuddin (9/30/2009)
David Walker-278941 (9/23/2009)
For table alises, programmers seem to get the idea that they are a required part of the syntax. In fact, for many readers, having to read...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
September 30, 2009 at 5:51 am
David Walker-278941 (9/23/2009)
Yes, but I'm not forgiving of superfluous apostrophes in the word "its". The sentence gets a Fail. "It's" means "it is" and nothing else.
Ah but if...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
September 23, 2009 at 8:43 am
I considered trying to say that, but couldn't figure out how to do so as clearly as @sknox just did :-).
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
September 22, 2009 at 12:43 pm
Viewing 15 posts - 31 through 45 (of 129 total)