declare @i int,@j int set @i=1 while @i<=1000 begin set @j=0 while @j<10 begin insert tb select @j*10000+@i,'...' set @j=@j+1 end set @i=@i+1 end
declare @n int set @n=0 declare @m bigint set @m=0 while @n<10 begin while (10000*@n+1<@m) and (@m<10000*(@n+1)) begin exec('insert into tb select'+ @m) set @m=@m+1 end set @n=@n+1 end
declare @j int set @j=1while @j<=10 begin insert #t select top @j*10000 * from tb set @j=@j+1 end
set @i=1
while @i<=1000
begin
set @j=0
while @j<10
begin
insert tb select @j*10000+@i,'...'
set @j=@j+1
end
set @i=@i+1
end
declare @n int
set @n=0
declare @m bigint
set @m=0
while @n<10
begin
while (10000*@n+1<@m) and (@m<10000*(@n+1))
begin
exec('insert into tb select'+ @m)
set @m=@m+1
end
set @n=@n+1
end
set @j=1while @j<=10
begin
insert #t
select top @j*10000 * from tb
set @j=@j+1
end