• terrykzncs (4/22/2011)


    Who uses a ';' anyway? it's not yet standard practice and if you do, you should realise that it would cause problems in the middle of a statement.

    For starters anyone that has to use Oracle. (Since it is required.)

    Also, Microsoft has deprecated not using ; so in the next version or two of SQL Server you will probably be required to, so it might be a good idea to start now so you don't have to go back and add the ; to all of your code later.

    From http://msdn.microsoft.com/en-us/library/ms143729.aspx:

    Not ending Transact-SQL statements with a semicolon.