Hmm. I executed the code and got:

(1 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '-'.

Looks like 1,0,1,error.

What is the...

Excellent question. I honestly had to run the code to get the correct answer but got a lesson on datetime2.

Great question. I'm getting more into XML from SQL and this was a good test.

My post was not a knock. It speaks more to my sloppy reading and assuming what I thought it should be. It was a great question!

Easy question but I have to learn to read. I picked the one that it wouldn't work on not the 5 it would. I guess I thought logically...

Great question. Had to use MSDN to confirm my answer but will never forget it now.

This question was very different to me as a newbie but I took a shot. Thanks for the 5 points.

Nice question. Thanks for a new bit of knowledge about Rename.

Thanks for the easy point. But after the indexes question the other day I thought it may be a trick question.

Great question. Tests some basics that sometimes trips us up.

This one was a real stinker. Seems like MSDN thinks 10 is the correct answer too!!

I stand corrected. I am seeing the column name. Thanks.

I go this wrong because I answered 1. But that was because if you execute the select statement again by itself, you will get one row returned. The...