belle’s sql musings

Executing Batches Multiple Times (SQL Server 2005 only)

Posted in DBA Toolbox / T-SQL Scripts, T-SQL Tips and Tricks by belle on June 12, 2008

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
Tagged with:

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

%d bloggers like this: