Excellent question. Defaults are always something to keep in mind and to avoid relying on, as they may change.

I must admit that when I first answered and got it wrong, I was very annoyed that it was a syntax question since, from the context, I didn't think that...

Good question.

Also, thanks John Arnott for the explanation. It makes sense.

Thanks for the question.

I haven't had any time to play with the Audit features yet (not currently a business requirement), but I figured if I was designing a feature like...

Excellent question. I learned something new from all the other posts, too. 🙂

Excellent question. Thanks.

Also, thanks to Oleg and Duncan for their explanations.

Good question and discussion.

Thanks all.

Good question.

Also, thanks for the added explanation, Hugo. I knew what everything was except for the Exclusive OR (^).:-)

Thanks.

--

Kevin C.

Good question. I also learned something new.

And thanks, as always, to Hugo for the great explanation.

🙂

Thanks for the excellent question, Paul. I am happy to say I learned this from you previously through your blog and I was able to get it right!

Thanks again.

Great question, Hugo. It made me do some research.

Thanks.

I personally didn't find the question confusing. And, although the syntax definitely is NOT advisable for readability, etc. it is interesting to know how SSMS will parse some code...

Great question.

I personally enjoy the questions that require more thought. This was enjoyable for me as I was able to 'troubleshoot' the code and then see the simple division...

Great question. I learned something new.

First off, like many others I find the site to be fantastic. I don't personally use the search engine very much (I use Google for all my searches) so...