Paul White NZ (4/21/2010)
Hugo Kornelis (4/21/2010)
I never understand that habit. The semicolon is a statement terminator, not a statement starter, so the logical place for it is at the end of a statement, not before the next one.This is one of those (perhaps irrational) things that bothers me too - it makes my brain jolt every time I see that ;WITH construction used. On the other hand, I dislike column lists prefixed with a comma (though I do see why people do that) as well, so maybe it is just me.
I'm one who likes to have the comma in front of the column in a list. I do it for ease of commenting out a line if I decide that column should not be included without having to comment out a comma somewhere else. Though - if people were consistent with their commas it wouldn't matter too much and things would line up more neatly.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events