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.
60 second software development tutorials and demos, and short blog posts.
60 second software development tutorials and demos, and short blog posts.