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

Rating: 0.0/10 (0 votes cast)

Rating: 0 (from 0 votes)

Be Sociable, Share!

belle’s sql musings