This example uses the Cars Table from the Example Databases.
UPDATE Cars SET TotalCost = TotalCost + 100 WHERE Id = 3 or Id = 4
Update operations can include current values in the updated row. In this simple example the
TotalCost is incremented by 100 for two rows:
A column's new value may be derived from its previous value or from any other column's value in the same table or a joined table.