insert into 你好表 select top 100000000 0 as col,1 as col2......from sysobjects a,sysobjects b,sysobjects c,sysobjects d,sysobjects e
create table #temp1(id1 int) Create table #temp2(id2 int)insert into #temp1 values(1)insert into #temp1 values(2)insert into #temp1 values(3) declare @p1 intset @p1=1while @p1<10 begin insert into #temp2 select * from #temp1
insert into #temp1 select * from #temp2 set @p1=@p1+1 endselect * from #temp1试试看。呵呵,慢。
insert 你的表 (列,列) select t5.c,t6.c from (select t1.b+t2.b*10+t3.b*100+t4.b*1000 c from (select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t1, (select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t2, (select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t3, (select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t4 ) t5, (select t1.b+t2.b*10+t3.b*100+t4.b*1000 c from (select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t1, (select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t2, (select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t3, (select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t4 ) t6
我曾经导过2000万条数据,花了两个小时。
应该求助于BCP
select top 100000000 0 as col,1 as col2......from sysobjects a,sysobjects b,sysobjects c,sysobjects d,sysobjects e
create table #temp1(id1 int)
Create table #temp2(id2 int)insert into #temp1 values(1)insert into #temp1 values(2)insert into #temp1 values(3)
declare @p1 intset @p1=1while @p1<10 begin
insert into #temp2 select * from #temp1
insert into #temp1 select * from #temp2 set @p1=@p1+1
endselect * from #temp1试试看。呵呵,慢。
select t5.c,t6.c from
(select t1.b+t2.b*10+t3.b*100+t4.b*1000 c from
(select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t1,
(select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t2,
(select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t3,
(select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t4
) t5,
(select t1.b+t2.b*10+t3.b*100+t4.b*1000 c from
(select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t1,
(select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t2,
(select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t3,
(select 0 as b union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t4
) t6