Viewing 15 posts - 2,341 through 2,355 (of 3,348 total)
Again, thanks for all the nice and encouraging comments. I have now decided to continue with the series. Sorry for those who did not like it and would rather not...
November 16, 2011 at 9:01 am
I was so caught up in responding to (and feeling bad about) the mistakes, that I forgot to thanks everyone for the kind words. All respondents to far have indicated...
November 16, 2011 at 4:12 am
Gazareth (11/16/2011)
Quick point - surely that should be with ShortDescription equal to 'None', LongDescription and ChgDate set to NULL ?
Yes, that is right. *curses self for not proofreading better*
Ah well....
November 16, 2011 at 3:19 am
vk-kirov (11/16/2011)
The...
November 16, 2011 at 1:06 am
Quick message to those who arrive here: I am aware that this question involves a lot of calculations - much more hard work than normal questions. So my compliments on...
November 16, 2011 at 12:09 am
L' Eomot Inversé (11/15/2011)
From the discussion I learnt that named constraints are allowed on temp tables; that is really awful - table variables have this one right.
Yes, that is awful...
November 15, 2011 at 11:34 am
Good questione, but the explanation is a bit too short. I assume Ron intended to write "You cannot create a named constraint on a table variable". On temporary and permanent...
November 15, 2011 at 2:15 am
martin.whitton (11/14/2011)
November 14, 2011 at 3:51 am
L' Eomot Inversé (11/13/2011)
But I wonder how long it will be before someone claims it's a trick question? :hehe:
Trick question! 😛
Just kidding, of course. Thanks for the question. I think...
November 14, 2011 at 2:34 am
SQL Kiwi (11/11/2011)
Hugo Kornelis (11/11/2011)
I'm afraid I don't understand how you came to that assessment.My comment was ironic / tongue-in-cheek.
Ah, okay. Thanks!
I'll see to getting that irony detector fixed. 😉
November 11, 2011 at 3:57 am
SQL Kiwi (11/10/2011)
Terrible question, and horrible answer. Thanks, I guess 😛
I'm afraid I don't understand how you came to that assessment. The question was fair, the answer could be...
November 11, 2011 at 1:58 am
Nice question, Ron!
I only got it right because I figured that the relative order of the date and time related values would be "logical". And since the conversion to smalldatetime...
November 10, 2011 at 2:51 am
tilew-948340 (11/9/2011)
Why the quey works fine if I remove the "order by 2" if its a conversion bug?
Because the bug is not introduced by conversion only, but by the combination...
November 10, 2011 at 2:40 am
Mike Dougherty-384281 (11/9/2011)
The number of ways of answering incorrectly: many
The is no "partially correct" option. I might have complained about mixing 4...
November 9, 2011 at 8:39 am
L' Eomot Inversé (11/9/2011)
Good question.The correct answer rate is still only 9%, which I find surprising.
Thanks!
I must say that the low rate of correct answers surprises me. I intended this...
November 9, 2011 at 5:07 am
Viewing 15 posts - 2,341 through 2,355 (of 3,348 total)