Owing to the absence of a "select two" hint I almost went for "all of the above", but saw sense and got it right.

I've obviously been doing these QotD for...

One of those occasions when it pays to answer the question without running the code!

Are there any circumstances where using SOME would be preferable to the equivalent with EXISTS?

Why would you expect people to know this? It's...

Not that easy - I assumed that there must be a catch so went for the non-obvious answer and got it wrong :hehe:

A nice question. But a shame that 'SQL String' wasn't an option, and that there was no reference as to what happens when you assign a value longer than the...

Might have been a bit trickier if it didn't come down to knowing how -5 was treated

Got this wrong, as it asked what output we'd get. I figured that "You can't use transactions on sp_configure" was an unlikely looking error message so ruled it out.

Turns out...

Not so much a typo, as forgetting to edit the text when it was copied and pasted from...

And if the first script is run together as a single batch, the table won't be created and the error message will be something else again!

It was possible to work this out by elimination - either both or neither of 4 and 5 had to be there, which ruled out all but 1 and 1,3....

GROUPING_ID was introduced in SQL2008. The others were all available in SQL2005.

Igor Micev (11/17/2014)

No reason at all, I was just curious as to what scenario might require it 🙂

Out of interest, what was the reason for needing to make this update? I can understand inserts (sort of) due to the need to support legacy data, but not clear...

What's a "Friday Shirt"? Something American I guess!