Very nice question. I could definitely see this happening in real world scenarios. I have to share this one with my coworkers. Nice job!

Easy syntax question. Thanks!

Thanks for the easy question! Good back to basics one.

Interesting question and nice insight from Hugo. Thanks to all!

Nice question and great explanations from everyone. Thanks!

Very nice write up. Thanks for posting it!

Thanks for an easy one to start the week off with.

I would have expected higher than 75% correct on this question. But then again, I use identity columns all the time. Good back to basics question. Thanks!

Thanks for the question Kapil. It brings up good points regarding joins.

Thanks for the article Dwain. Luckily I only use merge statements for updates and inserts. We rarely do deletes based on our business needs but I will definitely keep this...

I knew this had to be a trick question because I couldn't see why MS would add that command. As Tom said, rolling back a rollback is nonsense. Being April...

Outside of a hierarchy example, I can't think of when you would have a table foreign key reference to itself.

Very nice straight-forward question. This is something that I am going to discuss with our developers as I am sure there are systems where these could be useful. We generally...

Nice question. I've hit that precision issue before so I guessed correctly. I like that 2012 datefromparts function too.

Technically the answer is '0 ', but it was easy enough to deduce the answer choice that the author was looking for. If "None of the above" had been...