CODEWITHSUNDEEP
sqlt-sql
picknick
picknick

Reputation: 4007

What's the meaning of the GO-statement in TSQL

I'm new to TSQL and wondering what the GO statement really means. To me it just seems thrown in there where ever it seems to fit.

I guess it somehow tells sql server to run the previous statement? What happens if you don't use them at all? Could someone give an example where a statement will break if I don't use a GO.

Please elaborate.

Upvotes: 20

Views: 6857

Answers (3)

HLGEM
HLGEM

Reputation: 96552

It ends the batch.

It is rarely needed and is used far more often than it should be. One valid place is in stored proc programming where you first do a check if the proc exists and drop it if it doesn't. Then you use a go statement to end the batch because the create proc statement must be the first statement of a batch.

Upvotes: 10

JohnFx
JohnFx

Reputation: 34909

By the way. It isn't actually a TSQL command. It is just used by Microsoft DB tools to separate two batches of commands.

In fact you can configure it to be a different word in SSMS if you want to under the Optionss..Batch separation preference setting.

The main place this distinction is important is that SQL Will choke on GO statement if you try to use them in queries through a database connection from code, for example through ADO.NET.

Upvotes: 6

SQLMenace
SQLMenace

Reputation: 134961

It is a batch terminator

this will break

declare @i int
set @i =5

declare @i int
set @i =6

Select @i

Msg 134, Level 15, State 1, Line 5 The variable name '@i' has already been declared. Variable names must be unique within a query batch or stored procedure.

this will work

declare @i int
set @i =5

go
declare @i int
set @i =6

Select @i

Upvotes: 14

Related Questions