• 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