set rowcount 10000 insert into t select 'qq' from syscolumns a,syscolumns b set rowcount 0
CREATE TABLE [dbo].[tb] ( [col1] [int] IDENTITY (1, 1) NOT NULL , [col2] [nvarchar] (50) ) GOinsert into tb (col2) values('qq') declare @i int set @i=0 while (@i<13) begin insert into tb (col2) execute ('select col2 from tb') set @i=@i+1 end执行后,tb表中有8192条纪录
insert into t select 'qq' from syscolumns a,syscolumns b
set rowcount 0
[col1] [int] IDENTITY (1, 1) NOT NULL ,
[col2] [nvarchar] (50)
)
GOinsert into tb (col2) values('qq')
declare @i int
set @i=0
while (@i<13)
begin
insert into tb (col2) execute ('select col2 from tb')
set @i=@i+1
end执行后,tb表中有8192条纪录