执行语句N次 – GO N

by ·一条评论
go N :执行批语句N次

Create Table #Temp(SerialNo int identity Primary key, Product varchar(500))
go
 
Declare @Product varchar(500)
SET @Product='Mouse'
insert into #Temp(Product)
select @Product

GO 20

select * from #Temp
drop Table #Temp