SQL 执行插入1000万条数据操作 几十秒内!

alter database test set recovery BULK_LOGGED   
  go
insert into aaa  
  select id=a.id+b.id+c.id+d.id +e.id +f.id+g.id  
  from(   
  select id=0 union all select 1   
  union all select id=2 union all select 3   
  union all select id=4 union all select 5
  union all select id=6 union all select 7   
  union all select id=8 union all select 9   
  ) a,(   
  select id=0 union all select 10   
  union all select id=20 union all select 30   
  union all select id=40 union all select 50   
  union all select id=60 union all select 70   
  union all select id=80 union all select 90   
  ) b,(   
  select id=0 union all select 100   
  union all select id=200 union all select 300   
  union all select id=400 union all select 500   
  union all select id=600 union all select 700   
  union all select id=800 union all select 900   
  ) c,(   
  select id=0 union all select 1000   
  union all select id=2000 union all select 3000   
  union all select id=4000 union all select 5000   
  union all select id=6000 union all select 7000   
  union all select id=8000 union all select 9000   
  ) d,(  
  select id=0 union all select 10000   
  union all select id=20000 union all select 30000   
  union all select id=40000 union all select 50000   
  union all select id=60000 union all select 70000   
  union all select id=80000 union all select 90000   
  ) e,(
  select id=0 union all select 100000   
  union all select id=200000 union all select 300000   
  union all select id=400000 union all select 500000   
  union all select id=600000 union all select 700000   
  union all select id=800000 union all select 900000   
  )f,(
  select id=0 union all select 1000000   
  union all select id=2000000 union all select 3000000   
  union all select id=4000000 union all select 5000000   
  union all select id=6000000 union all select 7000000   
  union all select id=8000000 union all select 9000000   
  )g
   
  go   

alter database test set recovery full