Tom Garth (7/13/2010)
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.
As I understand it, MS considers their use to be "best practice" but the only times I'm aware of actually needing them is the case you mentioned, and any time you use a CTE -- you have to end any preceding statement with a semicolon.
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown