迁移历史sql数据

+ View Code?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

--select * into Trade2018 from Aozzo_ODS..Trade t1 --where t1.Created<'2019-01-01' --创建索引 --create index ix_Trade2018_created on Trade2018 (Created)   DECLARE @totalPage int --总页数 DECLARE @pageSize INT=1000 DECLARE @pageIndex INT=1   --var totalPage = (total + pageSize - 1)/pageSize; select @totalPage=(count(1)+@pageSize-1)/@pageSize from Trade2018 print @totalPage   while (@pageIndex<=@totalPage) begin   delete  Aozzo_ODS..Trade where tid in (            SELECT tid FROM (     SELECT ROW_NUMBER() OVER (ORDER BY Created ASC) AS 'RowNumber', * FROM dbo.Trade2018 ) AS tb WHERE RowNumber BETWEEN ( ( ( @pageIndex - 1 ) * @pageSize ) + 1 ) AND ( @pageIndex * @pageSize ) )   SET @pageIndex = @pageIndex+1 end       /* select t1.* into TradeItem2018 from Aozzo_ODS..TradeItem t1 where t1.PayTime<'2019-01-01'   create index ix_TradeItem2018_created on TradeItem2018 (paytime)     select   t1.*  into  TradeItem2018_temp from Aozzo_ODS..TradeItem t1 inner join trade2018 t2 on t1.Tid=t2.tid     */