我向数据库中插入1000条数据,可是为什么最后却是1022条呢?我实在是看不出是哪儿错了,希望高人能提示我一下。谢谢哈use test
go
declare @num int
set @num=0
while @num<1000
begin
insert into input(name, price) values('面包',100)
insert into input select * from input
set @num=(select COUNT(*) from input)
end结果却为:1022条
go
declare @num int
set @num=0
while @num<1000
begin
insert into input(name, price) values('面包',100)
insert into input select * from input
set @num=(select COUNT(*) from input)
end结果却为:1022条
insert into input(name, price) values('面包',100)
insert into input select * from input能解释一下你这句的意图么
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)你再试下,,,看成不成
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
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