CirquedeSQLeil (6/10/2010)
I don't see this as a trick question. I see it as a good question. There is something to be learned from this question and thus it is worthwhile.Thanks for the QOD.
I agree there may be some who might learn something from the question. A definite good question for them no doubt. But i thought the question had a typo and selected the wrong answer. How do i know if the syntax error was deliberate or just a mistake? We have had instances in the past where it was just a typo.
The first thing i do when i come to office is open my SSMS and then SSC QOTD. And when something like this happens it definitely irritates you a bit. Same happened with me.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/