Viewing 15 posts - 241 through 255 (of 584 total)
SQLRNNR (3/31/2013)
Interesting, I can use that set option in SP1 of SQL 2012.
Not having yet moved to SQL 2012, I had to wrote my own sp to do this. The...
April 1, 2013 at 5:02 am
Thanks for the question Ron.
I'm developing a bit of paranoia. Even when the question is easy for me, I figure that I am missing something.
As Andy Grove said, only the...
March 26, 2013 at 6:59 am
Dineshbabu (3/19/2013)
I expected there will be some trickery work will be there.. But it's easy and staright forward question..
I too looked for the trick. But, it's only easy if you...
March 20, 2013 at 5:06 am
Thanks for the question Ron. I usually do the QOTD within ten minutes of rising in the morning. So, it helps when it's short. Or, as in this case, on...
March 18, 2013 at 5:04 am
Knew that none of the given answers was correct. So, just picked one to see what the"official" answer was. As others, most completely Hugo, have said, the query can return...
March 12, 2013 at 5:22 am
As I post this, answer four has the lowest correct percentage of the four correct answers, an yet it is the only one without a valid alternative. Hmmmm ...
Thanks Ron...
March 11, 2013 at 5:22 am
When I saw the question, I knew it must be Monday. "Oriented in space and time? Check."
Thanks Ron for this, and your many other contributions.
March 4, 2013 at 5:08 am
demonfox (2/28/2013)
yes.. and I think , it would be same as this one
... (code removed for brevity) ...
a simpler look 😛
And, while not a great QOTD, this version would...
February 28, 2013 at 5:03 am
Thanks for the question Ron. Clever of you to have used the lower case 'w' to make the conspiracy minded believe this was yet another question on collation.
February 27, 2013 at 5:05 am
Koen Verbeeck (2/18/2013)
Spent 10 minutes looking for the catch, only to realize there wasn't one.
+1 and since I just got up, I figured I was missing something. So, I clicked...
February 19, 2013 at 5:08 am
ldorian81 (2/5/2013)
I knew there was a trick to this one,really good question thanks 🙂
Yes, I saw the NULL issue immediately, and then hit one of the checkboxes. Didn't even stop...
February 5, 2013 at 4:58 am
Nice question. Simple, but with a good point. Thank you Siddharth.
February 4, 2013 at 4:59 am
L' Eomot Inversé (1/31/2013)
It's quite clear that T-SQL is Turing Complete except in so far as it can have only finite resources, so there can be no argument that any...
January 31, 2013 at 7:03 pm
Nice one. I noticed the bit data type, but wasn't even thinking about binary vs decimal. Doh.
And I even told someone today the line I stole from (sorry can't remember...
January 29, 2013 at 7:39 pm
Viewing 15 posts - 241 through 255 (of 584 total)