• Koen Verbeeck - Thursday, July 12, 2018 1:24 AM

    If you need to resort to this, you have a very bad coding practice.

    Testify!

    One of my largest complaints about T-SQL is that Microsoft decided that the statement terminator operator would be optional.

    Officially not using semicolons to terminate every T-SQL statement is has been deprecated since the release of SQL Server 2008, "Although the semicolon is not required for most statements in this version of SQL Server, it will be required in a future version."

    The smart money is on Microsoft never making statement terminators mandatory. The amount of T-SQL code that would break is mind boggling.

    Nevertheless, everyone coding T-SQL should be using semicolons to terminate every statement.