Lynn Pettis (1/15/2010)
When taking a test, particularly a multiple choice (multiple guess, if you prefer) don't you read the entire question and the answers before actually answering the question?

Lynn Pettis (1/15/2010)

---

I don't read the QotD in the newsletter, I read it on SSC.

Mauve (1/15/2010)

---

And it is best to answer later in the day as the question is usually rewritten, often totally different than what was put in the email.

Mauve (1/15/2010)

---

And it is best to answer later in the day as the question is usually rewritten, often totally different than what was put in the email.

Lynn Pettis (1/15/2010)

---

Noticed that I have. Makes comments in discussion slightly confusing at times.

I've often wished the QOTD in the email included the title and it can't be that hard to include it.

Kevin Gill (1/15/2010)

---

To my mind, this question could/should have been moderated and edited to make it clearer.

Even though I would have got it wrong had it actually been asking what I thought it was, the fact that it was pretty badly written added an additional, unnecessary level of misdirection that just gets in the way.

The 'correct' answer does not in itself actually answer the question - I have no more idea now than I had ten minutes ago whether table VARIABLES in SQL2K5 can be set to NULL, even though I did actually know that you can't have table parameters in SQL 2K5 (as they would have solved a lot of my problems last year). I skimmed the answers, thought 'I know SQL2K5 can have table variables' (I admit - misreading on my part but I assumed that if it was a 'trick' question then that answer would refer to all parts of the question equally, given that there's only single word answers for the other options) and gave some thought to whether a table VARIABLE can be set to NULL or not. I made my choice, got it wrong, but didn't actually find out the answer.

So can table variables be set to NULL? Perhaps this could be added to the explanation...