Friday, November 26, 2010

What is other use of Go statement in TSQL?

I will explain you this with an Example.


CREATE TABLE dbo.TEST (ID INT IDENTITY (1,1), ROWID uniqueidentifier)
GO
INSERT INTO dbo.TEST (ROWID) VALUES (NEWID()) 
GO 1000

Note Second Go 1000.  This will insert 1000 row to table test.

No comments: