GO and batch execution multiple times.

Go is a useful command especially when you want to execute a batch multiple times. For time being we can take an example of inserting multiple dummy records in a table, with just ONE insert statement. Also read previous articles on GO

GO and the Stored Procedure

GO, is it a SQL command, a jump to pointer or what exactly?

GO and the Scope of variable.

Let’s create a temporary table for this purpose.

use testDemo

go --First Batch

create table #tempTable

(tempID uniqueidentifier,

tempMonth int,

tempDateTime datetime )

GO -- Second Batch

Command(s) completed successfully.

These batches will just execute these separate batches for once as default value for GO is one. Lets insert 100 records in our temporary table with just one insert statement

insert into #tempTable (tempID, tempMonth, tempDateTime)

select NEWID(),(CAST(100000*RAND() AS INT) % 12) + 1 ,GETDATE()

GO 10

Batch execution completed 10 times.

“Go 100” will execute this insertion batch for ten times, and exultantly 10 records will be inserted. That’s what I call it “Power of GO”. Check this.

select * from #tempTable

tempID                               tempMonth   tempDateTime

------------------------------------ ----------- -----------------------

C2055F4A-0FF9-4A2C-BB9F-9CC665EEC009 3           2013-03-25 14:30:37.830

4322FE78-4494-45B3-8923-5D9CD5F030CA 3           2013-03-25 14:30:37.933

86D89223-530B-423E-AAB1-8E65601D821B 8           2013-03-25 14:30:37.933

7E1A8812-9A8E-412D-8EE4-4FBE02FB4CBB 8           2013-03-25 14:30:37.937

917C89A6-1DFB-4375-A6E3-5C15F556AFCB 6           2013-03-25 14:30:37.940

7DEBDD5D-E2B9-45BB-9D65-D911DA32F431 7           2013-03-25 14:30:37.940

CC124777-7AE4-47A8-B7CA-0EE566D01465 5           2013-03-25 14:30:37.940

6A0E6F7C-47A6-4F2A-A8C0-58E4A0B498E2 4           2013-03-25 14:30:37.947

CB22E285-689A-466A-A7EB-E0734ED1435B 3           2013-03-25 14:30:37.950

7102D516-03AC-4EE9-93C8-820477E645D6 5           2013-03-25 14:30:37.953

(10 row(s) affected)

Now drop the temporary table

drop table #tempTable

Conclusion: GO can be used for multiple times batch execution.

Honk if you hate coding

Post Reference: Vikram Aristocratic Elfin Share