Good introduction the CHOOSE function.

As with the previous posts, I too got it wrong & disappointed with the wording of the question. I understood a UNIQUE CONSTRAINT to be a type of filter...

Good Question, learned something today.

Good Question!!!

Good Question. This question looks like it sparked an interesting discussion.

Just a follow up on enabling database mail.

On a new installation of SQL 2012, we clicked on the Database Mail icon under the Management folder in SSMS to start the...

Thanks to everyone's positive comments!

My explanation is however not correct "The extended stored procedure "sp_configure""...

Chris Büttner correctly identified that sp_configure is a stored procedure used to enable extended stored procedures....

Thanks! Interesting, made me think.

Actually it should be 2 points. If we have to debug the QofD, then there should be an extra point.

Just restating what has already been discussed: the error was on the insert, not the select statement. If you run the same select statement ten more time, you will...

I am not crazy about the wording, but I did learn about batch separators once I found where the setting was in SSMS.

-- Go to Tools -> Options -> Change...

Got Me, good question.

Yeaaa, I am in agreement with tommyh

There is a type-o in the question that produces a completely different result.

Query Messages:

--------------------------------

(1 row(s) affected)

(1 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)

Msg...

Good Article, I can relate to this one.

Ouch!!! Got me!!! - Excellent question, learned something new.