Viewing 15 posts - 46 through 60 (of 118 total)
Steve Jones - SSC Editor (8/3/2012)
I've edited the question down since I think it was a good question. I didn't catch the typo (grrr, no more images).I'll award points back.
Thank...
August 6, 2012 at 6:32 am
derek.colley (8/3/2012)
Answer is wrong, last query returns an error. Point refund please, my good sir!
i agree the last statement evaluates to
select * from #tmpTable --/*
where Fld1 = 0...
August 3, 2012 at 7:26 am
Good question, I knew the answer from personal experience. :blush:
August 1, 2012 at 6:45 am
Good question. It is good to know because you can use alias in the Order By clause but not the Where clause. The Select, and definition of an...
July 24, 2012 at 6:42 am
Rich Weissler (7/13/2012)
Presumably, if I were to load SQL 2008 R2 Data Center Edition on Windows Server 2012... it would...
July 13, 2012 at 6:37 am
If you are going to use BOL as your source (as I did) then at least make your answer line up with the source. There is no Note or...
July 9, 2012 at 5:56 am
I have to agree with every one else. The select statement is confusing.
First you start off with the declaration
"What values are returned for Test 1 and Test 2? "...
June 26, 2012 at 6:18 am
Hugo Kornelis (6/20/2012)
Revenant (6/20/2012)
Koen Verbeeck (6/20/2012)
paul.knibbs (6/20/2012)
a kilobyte has always been 1024 bytes as far as I'm concerned.For me, a kilobyte is still 1000 bytes. kilo = 1000
Sure. If a...
June 21, 2012 at 6:04 am
I dislike ambiguous questions like this. I would like to see someone install a 524TB DB on a 3TB drive
June 20, 2012 at 6:46 am
Thomas Abraham (6/19/2012)
A totally unrelated aside: Back from vacation. Missed the QotD. Didn't miss...
June 19, 2012 at 6:21 am
it really helped that #2 and #3 are exactly the same, then i knew about the distinct so by process of elimination.... 1 pt.
June 19, 2012 at 6:08 am
I just went through this for a user, nice timely question.
May 15, 2012 at 6:24 am
I only was able to answer the question correctly by assumption.
If the answer was no, then would there be a need to have an explanation. Every question has an...
February 17, 2012 at 6:29 am
Viewing 15 posts - 46 through 60 (of 118 total)