Rick Lang (6/21/2010)

---

Perhaps a different version of the question where the answer would be different with the Having clause vs just the where clause might help to clear up any...

forjonathanwilson (6/21/2010)

---

In 2008 creating temp tables on the fly has been severely restricted. creating more than a list of id's (or any other single column with first ordinal position) in...

Good question, but the explanation is lacking. I think that the +=, -=, etc operators are generally even better known than the bitwise operators used here (even if they were...

Lisa Phillip (6/18/2010)

---

I chose both tables... I believe that is ALSO a correct answer!

Think about it... where in this question did it say that col1 in the first table didn't...

Nice question!

I believe that far too many people use select into without really understanding what it does. This is not documented very explicitly; in ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/cc9bdf10-edfc-41a5-adf1-aa9715ed8d71.htm (link for SQL 2005 BOL),...

I agree fully. It's a terrible disappointment to see such a bad article being re-posted. Especially because people who do not read the comments, or stop...

Steve Jones - Editor (6/14/2010)

---

if we allowed that language, I'm more concerned there are plenty of people that wouldn't be able to restrain themselves and we'd have it written in...

ronmoses (6/14/2010)

---

I'm siding with the pedants on this one. I knew what was intended (and what the correct answer would be) but picked the error anyway, because that's how...

paul.knibbs (6/14/2010)

---

I said it would return zero thanks to the cropped NULL, but even without that, surely it would return 4 rows, not 3? I would expect the values from...

I don't really get the discussion on the chopped off graphic. If you assume an extra column there, the answer would be 4, which was not listed - making it...

sa_pachori (6/14/2010)

---

Hi,

the answer should be 1 which is not one of the available values so I selected one of the wrong options given.

What is asked is Select Count(*) which will...

I do not like this kind of question at all. The QotD should be a learning opportunity, with clear questions and no tricks.

There is nothing to be learned from this...

That's...

Interesting find, Jason. I missed my point because I believed Books Online. The only small critisism (sp?) I have on this question is the incorrect use of uppercase ("MODEL" instead...

Thanks, all, for the kind words.

There are five more in the pipeline, and some are simmering in the back of my head; I hope those won't disappoint you.