Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql query terminator(;) Expand / Collapse
Author
Message
Posted Tuesday, July 14, 2009 3:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 1, 2011 3:14 AM
Points: 11, Visits: 45
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:)
Post #752540
Posted Tuesday, July 14, 2009 3:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:55 AM
Points: 1,101, Visits: 5,280
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.
Post #752550
Posted Tuesday, July 14, 2009 9:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:36 AM
Points: 7,125, Visits: 13,172
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
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #752758
Posted Tuesday, July 14, 2009 10:33 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 10:01 AM
Points: 3,844, Visits: 3,841
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 - by Jeff Moden
Post #752857
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse