Viewing 15 posts - 2,296 through 2,310 (of 3,348 total)
Christian Buettner-167247 (12/14/2011)
Koen Verbeeck (12/14/2011)
I have a question:
why doesn't the second 'drop table' statement drop the table in the master database?
Won't the statement look for the table in the...
December 14, 2011 at 12:49 am
An interesting find, Ron.
What's even more interesting is that you get data from the table in master even if the current database has a different table with the same name....
December 14, 2011 at 12:36 am
Cadavre (12/13/2011)
December 13, 2011 at 3:45 am
A nice question, but a completely incorrect explanation!
The problem is not that each possibility is evaluated for each line. That's easy to check, just run:
SELECT CASE WHEN i <> 0...
December 13, 2011 at 3:44 am
Christian Buettner-167247 (12/12/2011)
December 12, 2011 at 7:26 am
Revenant (12/8/2011)
I am gettingMsg 102, Level 15, State 1, Line 1
Incorrect syntax near 'GO'.
on all 32,767 lines
That's because GO is not a T-SQL keyword, but a batch seperator, recognised and...
December 8, 2011 at 9:27 am
Jason Selburg (12/7/2011)
With the question being "What values are returned"
The correct answer...
December 7, 2011 at 9:47 am
L' Eomot Inversé (12/7/2011)
December 7, 2011 at 8:15 am
<sigh>
When will people finally learn that the US date format is NOT universal??
For a large majority of the world, the correct answer is 53, 31, 1, 32.
December 7, 2011 at 4:51 am
L' Eomot Inversé (12/6/2011)
Just one question on that: if I write it using a CTE which contains a join, does that count as a nested join?
I don't think there's a...
December 6, 2011 at 1:05 pm
SQL Kiwi (12/6/2011)
Hmm - but doesn't the CTE/derived table example break that assertion?
It does. I only realised the CTE possibility later, after I already posted that earlier post.
(For some reason...
December 6, 2011 at 6:48 am
Tao Klerks (12/6/2011)
Any objection to my adding it to my test suite (which is also the demo list on poorsql.com) once I've fixed it?
No problem for me!
Sorry for breaking your...
December 6, 2011 at 6:22 am
ronmoses (12/6/2011)
Would this not work as well?
Yup! (As you already found out after posting).
The only thing I don't like about your query is the semicolon before WITH. Semicolons belong at...
December 6, 2011 at 5:58 am
honza.mf (12/6/2011)
Probably I will use right joins and nested joins only in case of self-defense. I prefer the readability and I think from left to right.
Absolutely true. This question was...
December 6, 2011 at 5:50 am
SQL Kiwi (12/6/2011)
December 6, 2011 at 5:41 am
Viewing 15 posts - 2,296 through 2,310 (of 3,348 total)