Create Sample Table with Command GO [count] (T-SQL)Posted: March 31, 2011
By adding a number (n) after GO, the batch will exexute n times.
Here is a T-SQL snippet to create a sample table with 50 records in it:
CREATE TABLE myNumTable (id int identity(1,1),c1 datetime default getdate(), c2 varchar(50) default ‘test’)
The GO is the signal to start a batch of T-SQL statement but itself is not a T-SQL statement. It is recognized by the sqlcmd and osql utilities.