Viewing 15 posts - 2,326 through 2,340 (of 3,348 total)
Koen Verbeeck (11/27/2011)
Silly trick question...
It would be a silly trick question if the author intended it to trick us.
The "explanation" suggests that the question author fell for the trap himself....
November 28, 2011 at 3:27 am
Thanks, all, for the kind words! I am glad you all find my questions entertaining and informative.
martin.whitton (11/25/2011)
The MERGE statement is only available in SQL Server 2008 and later.
Oops! :blush:...
November 25, 2011 at 3:20 am
archie flockhart (11/23/2011)
November 23, 2011 at 12:10 pm
Interesting question. My gut feeling was that either the conversion to money or none of the conversions would be problematic for the empty string; I am glad I took the...
November 23, 2011 at 12:58 am
Ninja's_RGR'us (11/21/2011)
I know it depends, but I'm getting sick of making that argument so I was hoping one of you guys would take care ot that! 😉
I'll never tire of...
November 21, 2011 at 6:30 am
L' Eomot Inversé (11/18/2011)
I think 005 always rounds .005 ms to to .007 ms. I'm not sure I like that behaviour, but I think that's what it does.
I think...
November 18, 2011 at 5:20 pm
GPO (11/17/2011)
I would have written it
SELECT *
FROM #DateTest
WHERE SampleDate >= @DATE1
AND SampleDate < (@DATE2 + 1)
That would have worked for the "old"...
November 18, 2011 at 2:39 am
weisietan (11/18/2011)
the first data will counted but the last will not counted.
Example:
Name between 'A%' and 'C%'
just will get the...
November 18, 2011 at 2:35 am
Ola L Martins-329921 (11/17/2011)
GPO (11/17/2011)
November 17, 2011 at 1:16 pm
jeff.mason (11/16/2011)
November 16, 2011 at 2:42 pm
Iulian -207023 (11/16/2011)
I am not worried about the lost point, but is there anything I have missed?
No, that was my mistake. I added the index rebuild to the question to...
November 16, 2011 at 2:25 pm
SanDroid (11/16/2011)
Obviously lots of people learned today, including you. Lets have some more. It could even be worth some of the stale fruit you might recieve. :hehe:
No stale...
November 16, 2011 at 2:16 pm
SanDroid (11/16/2011)
So now I am confused again.Are the 47% that selected this answer to the question Right or Wrong? 😛
If I had the possibility to mark their answers...
November 16, 2011 at 2:14 pm
fhanlon (11/16/2011)
Since 200,474 pages equates to about 1.53 GB, you will not get error 1105.
I ran this code and I got error...
November 16, 2011 at 12:54 pm
SanDroid (11/16/2011)
I was editing my original post while you read and resonded to this. The original post did not comunicate what I intended.
No problem, that can happen. I'll go...
November 16, 2011 at 12:39 pm
Viewing 15 posts - 2,326 through 2,340 (of 3,348 total)