Executing Batches Multiple Times (SQL Server 2005 only)

In SQL Server 2005, we can execute batches multiple times using the following syntax following the GO delimiter

GO n

— Sample Script

   1: DECLARE @id int
   2:
   3: SELECT @id = MAX(id)
   4: FROM #tmp
   5:
   6: INSERT INTO #tmp
   7: VALUES (@id + 1)
   8:
   9: SELECT MAX(id)
  10: FROM #tmp
  11:
  12: GO 5
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s