This is what MSDN says (http://msdn.microsoft.com/en-us/library/ms191250.aspx):

A computed column is computed from an expression that can use other columns in the same table. The expression can be a noncomputed column name,...

Of course I got it wrong as probably all others trying this question. And it does not matter if you try to answer with or without SSMS.

QotD should try to...

BOL (http://msdn.microsoft.com/en-us/library/ms189463.aspx) states clearly

hence putting "Ann" as the correct answer is simply wrong.

Nevertheless, using...

Adding a WHERE clause is no option for two reasons:

1) It only works for INSERT...SELECT...WHERE... statements. If INSERT...(<field list>)VALUES(<value list>) is used, the WHERE clause is not available.

2) INSERT...SELECT...WHERE... may...

Hi,

I tried by typing everything in. I can get nothing but the error message "[font="Courier New"]invalid object name 'dbo.items'[/font]". 🙁

Oh what a shortsighted question! 🙁

ASCII is a US only standard, hardly usable anywhere else. Ever thought about Europe? Do you really think the French, German, Scandinavian, Czech, Slovak, Slovene,...

BOL simply state

ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($). For...

Still you...

Does not work as described.

Personally I do not like questions where the correctness of your answer changes with your luck.

Steve Jones - Editor (2/26/2010)

---

The answers have been edited to include the column and "none of the above" has been changed. I will award back points. My apologies as I...

Once again a crap QotD.