Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Table updates on large table with no ID or large gaps between IDs RE: Table updates on large table with no ID or large gaps between IDs

  • December 20, 2017 at 7:35 am

    #1972900

    If you want to update 10,000 rows at a time, you can use an UPDATE TOP (10000) ... ORDER BY ID statement in your loop.  You'll probably need an OUTPUT clause so that you know when to stop!

    John