create table #temppp(tmpNo int,tmpName varchar(10),TmpStatus char(1))
declare @a int
set @a=1
while @a<=5000
begin
insert into #temppp(tmpNo,tmpName,TmpStatus) values('1000','今天','1')
set @a=@a+1
end
drop table #temppp
我的机器用0.04秒,如果你的机器高级,执行速度更快
DECLARE @i int
SET @i=2
WHILE @i<=250000
BEGIN
INSERT INTO TGongwen(GfaRiqi,GfaYonghu,Greader,Gtitle) values('2004-2-5','通信科','通信科,办公室,王局长,刘局长,张局长,admin,刑侦支队,特勤支队,交巡警支队,经侦支队, 户政科,治安支队,外事科','这是最先的25万条记录')
set @i=@i+1
end