-- 1111111111111111111111111


USE CMAP_Dev
GO

-- *********************
-- Option 1 - While Loop
-- *********************
CREATE TABLE dbo.TEST (ID INT IDENTITY (1,1), ROWID uniqueidentifier) 
CREATE TABLE dbo.TEST2 (ID INT IDENTITY (1,1), ROWID uniqueidentifier) 
GO 

DECLARE @counter INT  
SET @counter = 0  
WHILE @counter < 1000  
  BEGIN 
       INSERT INTO dbo.TEST (ROWID) VALUES (NEWID()) 
       INSERT INTO dbo.TEST2 (ROWID) VALUES (NEWID()) 
  SET @counter = @counter + 1 
  END
GO

-- Review the records
SELECT * FROM dbo.TEST 
SELECT * FROM dbo.TEST2
GO

-- DROP the tables
DROP TABLE dbo.TEST 
DROP TABLE dbo.TEST2
GO

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


-- Review the records
SELECT * FROM dbo.TEST 
GO

-- DROP the tables
DROP TABLE dbo.TEST 
GO

-- ********************
-- Option 3 - Double GO
-- ********************
CREATE TABLE dbo.TEST (ID INT IDENTITY (1,1), ROWID uniqueidentifier)  
CREATE TABLE dbo.TEST2 (ID INT IDENTITY (1,1), ROWID uniqueidentifier)  
GO  
INSERT INTO dbo.TEST (ROWID) VALUES (NEWID())  
INSERT INTO dbo.TEST2 (ROWID) VALUES (NEWID())  
GO 1000

-- Review the records
SELECT * FROM dbo.TEST 
SELECT * FROM dbo.TEST2
GO

-- DROP the tables
DROP TABLE dbo.TEST 
DROP TABLE dbo.TEST2
GO
