Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Insert data in multiple batches for millions of record RE: Insert data in multiple batches for millions of record
Joe Torre
SSChampion
Points: 10248
More actions
December 7, 2017 at 9:30 am
#1971197
Use SSIS. It will handle inserts in batches behind the scenes without having to roll your own solution. You can do it manually using ORDER BY with OFFSET.