Microsoft SQL Server
The T-SQL Merge statement
You have a table A with new data, and a table B with old data. How do you make sure table B is refreshed with data from table A? You want to insert new records, update existing records and to delete removed records.
The T-SQL merge statement can do all that for you.