insert into tb1 select top 2500 * from tb order by name ,sj insert into tb1 select top 5000 * from tb order by name ,sj except select top 2500 * from tb order by name ,sj insert into tb1 select top 5000 * from tb order by name desc ,sj desc except select top 2500 * from tb order by name desc ,sj descinsert into tb1 select top 2500 * from tb order by name desc ,sj desc
--如果不要求数据规则 select top (25) percent * from 表
唯一规则 sj 或者 name 相同的最好分到一起。
唯一规则 sj 或者 name 相同的最好分到一起 ----- 那先处理下 sj, name 表select sj into #tmp from YourTable group by sj然后 insert into tb1 select top 2500 * from tb order by name ,sj insert into tb1 select top 5000 * from tb order by name ,sj except .... 再根据#tmp 表分四份。
select top 2500 * from tb order by name ,sj insert into tb1
select top 5000 * from tb order by name ,sj
except
select top 2500 * from tb order by name ,sj insert into tb1
select top 5000 * from tb order by name desc ,sj desc
except
select top 2500 * from tb order by name desc ,sj descinsert into tb1
select top 2500 * from tb order by name desc ,sj desc
select top (25) percent *
from 表
唯一规则 sj 或者 name 相同的最好分到一起。
-----
那先处理下 sj, name 表select sj
into #tmp
from YourTable
group by sj然后
insert into tb1
select top 2500 * from tb order by name ,sj insert into tb1
select top 5000 * from tb order by name ,sj
except
....
再根据#tmp 表分四份。