declare @i int
set @i=0
while @i<100
begin
insert into table1 (id,ta) values (@i,'sgfdeterte')
@i = @i + 1
end
set @i=0
while @i<100
begin
insert into table1 (id,ta) values (@i,'sgfdeterte')
@i = @i + 1
end
文本中可以考虑bcp导入,如果是是程序中可以考虑按条插入.
如果表尚未建立,可以:
select top 100 [id]= identity(int,1,1),TA='ssss' into table1 from sysobjects a,sysobjects b