重启下SQL服务,删除掉TB表中的数据,重新插入insert into tb select * from( select ...from b1 union all select ...from b2 union all select ...from b3 union all select ...from b4 union all select ...from b5 )t
1000的5次方我都不会读。 select ltrim(number)+'b1' as number into b1 from master..spt_values where type='p' and number<1000 select ltrim(number)+'b2' as number into b2 from master..spt_values where type='p' and number<1000 select ltrim(number)+'b3' as number into b3 from master..spt_values where type='p' and number<1000 select ltrim(number)+'b4' as number into b4 from master..spt_values where type='p' and number<1000 select ltrim(number)+'b5' as number into b5 from master..spt_values where type='p' and number<1000select top 10000 * from b1 cross join b2 cross join b3 cross join b4 cross join b5 where b1.number>b2.number and b2.number>b3.number and b3.number>b4.number and b4.number>b5.number /* number number number number number -------------- -------------- -------------- -------------- -------------- 2b1 1b2 10b3 100b4 0b5 2b1 1b2 10b3 104b4 102b5 2b1 1b2 10b3 104b4 103b5 2b1 1b2 10b3 105b4 0b5 ... 2b1 1b2 13b3 12b4 118b5 2b1 1b2 13b3 12b4 119b5 2b1 1b2 13b3 12b4 120b5 2b1 1b2 13b3 12b4 121b5 ... 2b1 1b2 17b3 138b4 112b5 2b1 1b2 17b3 138b4 113b5 2b1 1b2 17b3 138b4 114b5 2b1 1b2 17b3 138b4 115b5 ... 2b1 1b2 17b3 149b4 146b5 2b1 1b2 17b3 149b4 147b5 2b1 1b2 17b3 149b4 148b5 2b1 1b2 17b3 150b4 0b5(10000 row(s) affected)*/
select *
from(
select ...from b1
union all
select ...from b2
union all
select ...from b3
union all
select ...from b4
union all
select ...from b5
)t
select ltrim(number)+'b1' as number into b1 from master..spt_values where type='p' and number<1000
select ltrim(number)+'b2' as number into b2 from master..spt_values where type='p' and number<1000
select ltrim(number)+'b3' as number into b3 from master..spt_values where type='p' and number<1000
select ltrim(number)+'b4' as number into b4 from master..spt_values where type='p' and number<1000
select ltrim(number)+'b5' as number into b5 from master..spt_values where type='p' and number<1000select top 10000 * from b1
cross join b2
cross join b3
cross join b4
cross join b5
where b1.number>b2.number and b2.number>b3.number
and b3.number>b4.number and b4.number>b5.number
/*
number number number number number
-------------- -------------- -------------- -------------- --------------
2b1 1b2 10b3 100b4 0b5
2b1 1b2 10b3 104b4 102b5
2b1 1b2 10b3 104b4 103b5
2b1 1b2 10b3 105b4 0b5
...
2b1 1b2 13b3 12b4 118b5
2b1 1b2 13b3 12b4 119b5
2b1 1b2 13b3 12b4 120b5
2b1 1b2 13b3 12b4 121b5
...
2b1 1b2 17b3 138b4 112b5
2b1 1b2 17b3 138b4 113b5
2b1 1b2 17b3 138b4 114b5
2b1 1b2 17b3 138b4 115b5
...
2b1 1b2 17b3 149b4 146b5
2b1 1b2 17b3 149b4 147b5
2b1 1b2 17b3 149b4 148b5
2b1 1b2 17b3 150b4 0b5(10000 row(s) affected)*/