Listing 3: UPDATE Showing How SQL Server Handles Bulk Modifications

UPDATE SalesOrderHeader
SET  CustomerID = CustomerID + 100000,
ContactID = ContactID + 100000,
SalesPersonID = SalesPersonID + 1000