Thanks for the question.

Got it wrong, and I even ran a test. Code below:

CREATE TABLE #Temp(Col1 INT NOT NULL

CONSTRAINT PK_QOTD_1 PRIMARY KEY (Col1))

INSERT #Temp(Col1)...

HanShi (5/15/2012)

Unfortunate I was one of the 45% answering wrong :(. I answered this from the top of my head and thought the folder would be visible but not able...

Thanks for the question. I'd like to see more questions on sys tables/views. Please.

Thanks to OP for question - learned something, which is a good way to start the day. I almost always use ISNULL(), unless I need a three or more way...

SQL Kiwi (5/5/2012)

Datetime values are no more "associated" with a float value than they are with any other type that can be implicitly converted (see the conversion table in Books...

Thanks for the question. My gratitude is in no way influenced by the fact that I selected the correct answer. 😉

However, I'm leary of questions that rely on a reference...

I'll plead guilty to being clueless about the context as well. Already twice as many misses in May as in April! 🙁

Still, perhaps a little more care (and original effort?)...

Argh! Blew right past the CYCLE/NO CYCLE option explanation in BOL, looking for behavior when min value exceeded. SHould have had that first cup of green tea.

Thanks for the question!...

Typical. I had to go to a non-Microsoft website to find...

Nice question Koen. Thanks!

And thanks for writing your own explanation for the answer! 😉

Tom raises some very good issues. As always he elevates the level of the discussion.

Having followed the link suggested, curiosity got the best of me. I entered "recursion" in Standford's...

Sometimes true wisdom is...

Actually, just stating that one or more answers may be correct would be enough. But, in...

bitbucket-25253 (4/24/2012)

My apologies .... YOU ARE CORRECT

I should have finished my first cup of coffee before even attempting to answer and then wondering why what I selected was incorrect.

Again...

Removed as issue is moot now that Ron is back in our space-time continuum.