更新时间:2023-01-23 09:45:48
我认为您可以将 SQL 2012 的分页函数 OFFSET
和 FETCH
与 bcp 结合使用:>
I think you could use SQL 2012's paging functions OFFSET
and FETCH
in conjunction with bcp:
SELECT *
FROM Table
ORDER BY ID --Primary Key
OFFSET 100000001 ROWS
FETCH NEXT 100000000 ROWS ONLY