SQL Server has a MERGE statement that lets you do multiple actions in one statement - possibly inserts, updates, and deletes all at once.
Here's an example that shows this in action.
View code on GitHub