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