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
Steve Jones - SSC Editor
SSC Guru
Points: 734301
More actions
December 7, 2017 at 11:34 am
#1971249
Joe Torre - Thursday, December 7, 2017 9:30 AMUse 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.
+1