Tom Garth (7/13/2010)
I got it right for the wrong reason. I didn't notice the semi-colon, and since A. would not have been a complete answer, I chose C. which amounted to "None of the above."
Why do you think A would not have been a complete answer?
I've only used semi-colons for multiple short statements on a single line. I've never heard any pros or cons regarding using them or not using them.
They are already required before some new language constructions (like WITH). But Microsoft has also announced that the optionality of the semicolon seperator will disappear in a future version. So in a few years time, it will be mandatory to terminate EVERY statement with a semicolon. (Like almost all other computer languages).
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis