20

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.

picknick
  • 3,897
  • 6
  • 33
  • 48
  • possible duplicate of [T-SQL GO Statement](http://stackoverflow.com/questions/2668529/t-sql-go-statement) – Thomas May 25 '10 at 14:01

3 Answers3

14

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
SQLMenace
  • 132,095
  • 25
  • 206
  • 225
10

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.

HLGEM
  • 94,695
  • 15
  • 113
  • 186
  • 1
    Another valid and common place is with ALTER VIEW commands in your TSQL. `'ALTER VIEW' must be the only statement in the batch`. I.e., it needs a `GO` before and after the ALTER VIEW. – Don Cheadle Oct 11 '17 at 15:29
6

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.

JohnFx
  • 34,542
  • 18
  • 104
  • 162