Post reply

Semi-colon use

  • August 14, 2007 at 7:20 am

    #118163

    Hi

    I have noticed the use of semi-colon ";" at the end of some code I am inheriting in my new organization can anyone explain exactly what the semi-colon is doing in the code.  I am having difficulty finding any documentation on this in the help files.

    I am assuming it is some sort of end of statement indicator may be simular to a go statement not sure.

    Thanks,

  • August 14, 2007 at 7:31 am

    #726762

    the semi colon is a way to separate different sql statements, but it does not make a difference in sql server. maybe they will enforce it in years to come.

    Everything you can imagine is real.

  • August 14, 2007 at 8:52 am

    #726816

    It is also required in specific instances in SQL Server 2005.

  • August 14, 2007 at 9:30 am

    #726839

    mmm.. which instances

    Everything you can imagine is real.

  • August 14, 2007 at 11:18 am

    #726869

    CTE's

     

    N 56°04'39.16"
    E 12°55'05.25"

  • August 17, 2007 at 11:50 am

    #727728

    i have actually realised that you can also use the semi colon when u have multiple statements in a query when using sp_send_dbmail

    Everything you can imagine is real.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply