Just Learned - Sql Server - 'GO N' clause will repeat batch N Times

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

Sql Server - 'GO N' clause will repeat batch N Times

Sep 1 2011 9:44AM by Sandeep Prajapati

In SQL Server, 'Go N' will execute the bunch of commands within the batch 'N' times

Create Table #Temp(SerialNo int identity Primary key, Product varchar(500))
go

Declare @Product varchar(500)='Mouse'
insert into #Temp(Product)
select @Product
GO 20

select * from #Temp
drop Table #Temp

5 Comments

Hi Sandeep,

I have used GO with x number of times to insert sample records in table here, http://beyondrelational.com/blogs/paresh/archive/2011/04/07/sparse-column-new-feature-of-sql-server-2008.aspx

commented on Sep 1 2011 8:22AM

Paresh Prajapati

6 · 22% · 7102

To be more accurate, If the batch separator in SSMS is configured as "GO" then SSMS will execute the given TSQL statement "N" times if it is followed by "GO N".

Keep in mind that, GO is not a SQL Server command. It is just a separator that SSMS uses it. Also, remember that you can change the batch separator from GO to something else too.

commented on Sep 1 2011 9:59AM