Rows in the source are matched with rows in the target based on the join predicate specified in the ON clause. One insert, update, or delete operation is performed per input row.
In SQL Server 2008, you can perform multiple data manipulation language (DML) operations in a single statement by using the MERGE statement.
For example, you may need to synchronize two tables by inserting, updating, or deleting rows in one table based on differences found in the other table.
In Oracle, when you need to update values of certain records from one table, and the value and the records to update are determined by a second table, you can use a subquery in the update statement to achieve the updating efficiently.
I ran into a situation today when I need to update 10,000 records in a master table totaling 1,000,000 rows, and the value that I'm going to use comes from the accounting department. In sum, accounting wants to update job 103's invoice amount to $400 and job 104's invoice amount to $600, while leaving all other amounts the same.
What is the SQL update syntax to update more than one column?