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: