Loop execution-Go

Sometimes in order to test, a large amount of data is simulated, SQL Server 2005, you can loop through the GO statement to perform the insert

Example 1: Circular insertion

IF object_id (' TB1 ') is not nulldrop table Tb1create table TB1 (ID INT IDENTITY, NAME VARCHAR (), dtdate DATETIME) GO--Be sure to Plus go, or go 100 will loop from the beginning insert into TB1 VALUES (' TEST ' +convert (Varchar,convert (Int,rand () *100)), GETDATE ()) Go 100SELECT COUNT (*) Count from TB1

Loop execution-Go