select identity(int,1,1) as tmpid, * into #t from table
select columnA... into tableA from #t where tmpid<=100
select columnA... into tableB from #t where tmpid<=150 and tmpid>100
select columnA... into tableC from #t where tmpid>150
drop table #t
select columnA... into tableA from #t where tmpid<=100
select columnA... into tableB from #t where tmpid<=150 and tmpid>100
select columnA... into tableC from #t where tmpid>150
drop table #t
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货