declare @i int set @i=0 while @i<1000000 begin insert int_test select @i set @i=@i+1 end
insert int_test select top 1000000 1 from syscolumns a, syscolumns b, syscolumns c, syscolumns d, syscolumns e, syscolumns f
with s1 as(select 1 as c union all select 1), s2 as(select 1 as c from s1 A, s1 B), s3 as(select 1 as c from s2 A, s2 B), s4 as(select 1 as c from s3 A, s3 B), s5 as(select 1 as c from s4 A, s4 B), s6 as(select 1 as c from s5 A, s5 B) create table tttttt (id int)insert into tttttt select top 1000000 c from s6
set @i=0
while @i<1000000
begin
insert int_test select @i
set @i=@i+1
end
select top 1000000 1
from syscolumns a,
syscolumns b,
syscolumns c,
syscolumns d,
syscolumns e,
syscolumns f
with
s1 as(select 1 as c union all select 1),
s2 as(select 1 as c from s1 A, s1 B),
s3 as(select 1 as c from s2 A, s2 B),
s4 as(select 1 as c from s3 A, s3 B),
s5 as(select 1 as c from s4 A, s4 B),
s6 as(select 1 as c from s5 A, s5 B)
create table tttttt (id int)insert into tttttt select top 1000000 c from s6
能给我解释几下syscolumns是什么意思,有什么用吗???