Update with Output in SQL Server

Posted by Joe Enos on February 26, 2021 · 1 min read

If you're doing an update, and need information on the records you're updating, you can do it all in a single command. This video gives you an example using a CTE, where you update, and also pull data down from the records that you're updating, all in a single command.

View code on GitHub