[SQL] Using 'GO 100' to execute a batch 100 times

http://weblogs.asp.net/jgalloway/archive/2007/04/25/sql-using-go-100-to-execute-a-batch-100-times.aspx

이런 팁이 있었다니. 크하하하하 ^___^

SET NOCOUNT ON

GO

 

CREATE TABLE dbo.TEST (ID INT IDENTITY (1,1), ROWID uniqueidentifier)

GO

-- 1000번의 배치실행한다.

INSERT INTO dbo.TEST (ROWID) VALUES (NEWID()) 

GO 1000

 

SELECT *

fROM TEST

 

>> 잼나다 ^___^ 요런 트릭도 있다니.ㅋㅋㅋ