Browse DevX
Sign up for e-mail newsletters from DevX

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



Building the Right Environment to Support AI, Machine Learning and Deep Learning

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>


<Second Statement>
Srinivasa Reddy
Comment and Contribute






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



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