As many have said, this is a pretty awful question and answer. ...

A query specifically about SQL Server 2005 with a reference to http://msdn2.microsoft.com/en-us/library/ms178071(SQL.100).aspx in the explanation seems a bit strange, to say the least. That ".100" should be ".90".

Stefan Krzywicki (2/5/2010)

---

I realize this is an old question, but I'm killing time while waiting for a remote install to finish. This is a terribly worded question. The correct answer...

Nice question. Strange error in the explanation - I think someone typed "additive" when they meant "semi-additive".

I mistakenly read the possible answers as meaning what they said, which clearly meant that neither of the two containing the word "only" could be correct as if one of...

Lynn Pettis (4/18/2008)

---

Definately not an intuitive error message. Just reading it you would think syntax error. If trying to restore a 2005 database to a 2000 server you'd...

Nice question, terrible explanation. SQL doesn't even have a concept of default values for its various datatypes.

Happy new year everyone.

I'm off to have dinner and watch the fireworks.

Carlo Romagnano (12/30/2010)

---

Try this for fun:

DECLARE @MyTable TABLE (Col1 INT,

...

CirquedeSQLeil (12/28/2010)

---

sing4you (12/28/2010)

---

Words...

Richard Warr (12/26/2010)

---

I wasn't expecting the question to appear today - I was advised it would be tomorrow. That would have given me the opportunity to express the "fun" side...

Yes, I agree that it's useful having a dropdown list is much better than having free text input, and you certainly want to populate the dropdown from the database. ...

I learned something here - I expected it to fail because I thought datetime2 literals were required to specify time to the second (or more precisely), so I got it...

Just working backwards through all questions because it helps me learn...

Not if the website is competently designed...