111,097
社区成员




declare @num int
declare @TEMP int
set @num=0
SET @TEMP = 1
while @num<1000
begin
insert into input(name, price) values('面包',100)
insert into input select * from input
set @num=(select COUNT(*) from input)
PRINT '循环次数:'+CONVERT(NVARCHAR(10),@TEMP)+',总记录数:' + CONVERT(NVARCHAR(10),@num)
set @TEMP = @TEMP +1
end
use test
go
declare @num int
set @num=0
while @num<1000
begin
insert into input(name, price) values('面包',100)
set @num = @num + 1
end
print @num
use test
go
declare @num int
set @num=0
while @num<1000
begin
insert into input(name, price) values('面包',100)
end
set @num=(select COUNT(*) from input)