Viewing 15 posts - 31 through 45 (of 48 total)
Even though the question said "the three options", I went and picked only two. I've never used the resource governor, so I wouldn't have gotten it right anyway. =P
This made...
April 5, 2013 at 12:18 pm
Yet another humor question that went right over my head. I really should stop answering these before coffee... there go seven whole points! :crying:
April 1, 2013 at 8:32 am
L' Eomot Inversé (3/16/2013)
Nice question, and fine explanation, but that bit about "59.005" seems to have come from a different than the rest. 😉
I thought that part was weird too,...
March 18, 2013 at 8:32 am
This behaviour isn't exclusive to select into, it has to do with how SQL Server determines data types from values that aren't explicitly typed. For example:
select case when 1 =...
March 13, 2013 at 7:23 am
buddy__a (3/8/2013)
I'm still waiting for someone to fix this. The answer saying "ORDER By is required when using a TOP clause" is clearly wrong.
It seems Steve isn't around. He...
March 8, 2013 at 4:01 pm
wolfkillj (3/8/2013)
(...) The question and answers all come from this single short paragraph from BOL (...)
You forgot the part about nesting limit - which, by the way, I don't find...
March 8, 2013 at 10:03 am
Got it wrong because I thought Output.ID was an identity column and couldn't receive insert values. D'oh!
Noticed the difference in capitalisation, but assumed the base to be case-insensitive, as it...
February 27, 2013 at 8:45 am
Thanks for the question!
I marked B because I didn't realize the brackets would make any difference in the 9 - 5 + 8 part, since they're all in the same...
February 6, 2013 at 9:56 am
Hugo Kornelis (2/5/2013)
Very good question, and an awesome explanation. (Apart from one small type that you probably put in deliberately to prove that you're still human).Thanks, Tom!
+1
When I started reading...
February 5, 2013 at 9:22 am
Really need to stop answering these before coffee. 😛
February 4, 2013 at 5:20 am
wolfkillj (1/29/2013)
(...)(And yes, I know I spelled DR0P TABLE with a zero instead of an "O". (...))
I thought you were just trying to be 1337. :hehe:
January 29, 2013 at 8:38 am
Weird, I was so sure I recently got a question wrong exactly because I thought truncate reseeded the identity and it actually didn't. Guess I was just confused. 😛
Thanks for...
December 19, 2012 at 9:55 am
Viewing 15 posts - 31 through 45 (of 48 total)