22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT 字段,ROW_NUMBER()OVER(ORDER BY GETDATE()) AS rownum INTO #temp FROM 表
SELECT 字段 FROM #temp WHERE rownum<1000000
SELECT 字段 FROM #temp WHERE rownum BETWEEN 1000000 AND 2000000
......
SELECT 字段,ROW_NUMBER()OVER(ORDER BY 1) AS rownum INTO #temp FROM 表
SELECT 字段 FROM #temp WHERE rownum<1000000
SELECT 字段 FROM #temp WHERE rownum BETWEEN 1000000 AND 2000000
......