Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Intermediate
Dec 21, 2001

Using the GO Command in SQL Server Query Analyzer (T-SQL)


The GO Command sends the current batch of Transact-SQL statements to SQL Server as a batch. The current batch of statements is composed of all those statements entered since the last GO. They are compiled into a single execution plan. If two statements are running in SQL Server Query Analyzer, and the first statement shows the error, the second statement execution stops automatically. If you use the GO command between these two statements, the Query Analyzer will consider each statement as a separate batch. So if the first statement execution stops due to errors, then it will go on to the second statement execution.
 
<First Statement>

GO

<Second Statement>
Srinivasa Reddy
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date