Better question would be "What version is your database?" Because I've seen DBs older than that, but at least they upgraded the engine version. 😛

Even if it is not commented out, option four returns two values, only one of them the right one, so really guessing the intent of the is borderline impossible.

Unless the question specifies otherwise,...

I'm new enough to SQL server I did not even know this syntax. I thought it might be a typo, but I looked it up just in case. ...

Trying to figure out what the question had to do with a computed column had me stymied for a few minutes. I kept going back over it, trying to...

But is the reverse true? 😛

Would have been simple, if I had read the question right...

I am split on this matter. When not faced with a stream of meetings or interruptions, I am far more productive at the office. I have a dedicated...

I tend to agree that the question should be 'What is syntactically wrong with this table?'

Because the syntax may work, the table in question is wrong on so many level...

Of course the correct answer is it throws an error, because nobody has a table named 'MyTable'. And if they do, the 'test' column is a GUID. :hehe:

I agree with most of this, except for data 'custodians' receiving exemptions. 'I was just following orders' is no excuse for abandoning personal moral and legal responsibility. Maybe...

I don't have a laptop. On those rare occasions when I have been sent somewhere and needed a laptop, I had a loaner with minimal data and the ability...

I picked 1 & 3 option, because they were definitely going to throw an error. I wasn't aware of the "shouldn't use 'sp'" rule, which would make #1 doubly...

I'm more upset it isn't Halloween themed,...

Hey, now. We should all be united against management that doesn't give us adequate resources in the first place. Otherwise we would have a dev/QA (or both separate,...