Post reply

Sql query terminator(;)

  • July 14, 2009 at 3:39 am

    #73240

    Hi all,

    As we know semicolan is a query terminator when we run queries in batch. We also know that (;) is optional to use.

    Ex: select * from table1;select * from table2;

    Now my question is , can we use any other operator instead of (;).

    If yes then are there any settings to do so.

    If no please provide some links that say no.

    Its urgent:)

  • July 14, 2009 at 3:59 am

    #1024298

    Why do you want to use any other operator instead of ;?

    The semicolon character is a statement terminator. It is a part of the ANSI SQL-92 standard.

    SQL Server 2008 Books Online (June 2009)

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

    Transact-SQL statement terminator.Although the semicolon is not required for most statements in this version of SQL Server, it will be required in a future version.

  • July 14, 2009 at 9:06 am

    #1024470

    triple post.

    please see here and here . All posts have one answer so far, making it hard to tell where to continue if required...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • July 14, 2009 at 10:33 am

    #1024557

    You've asked the same question 3 different times, 3 different ways and you've stated that it is urgent, but you have not told us what your problem is. Are you having problems not using statement terminators or with using the semicolon?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 4 posts - 1 through 3 (of 3 total)

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