Using the TSQL Output Clause
The SQL Server output clause is a great way to get data back from an insert, update or delete statement, and it cause be used for auditing, or tracking of changes. It is also a great way to capture changes for a type of undo mechanism if needed. One over the more overlooked SQL Server features that can help you write more effective queries.
This course is part of the Querying SQL Server series.
What people are saying about this course
The Output Clause one was “new” knowledge for me as I never used/researched it…. I’m using it multiple times per day now.
-- George (Course Student)
I watched the whole course. Really great lesson.
-- Mo
What you are getting
A focused course on how to the OUTPUT clause in your INSERT, UPDATE and DELETE queries. This is part of our SQL Short courses which are very focuses and value priced.
When you complete all the course material, you will receive an email with a certificate showing you completed the course. You can print that out and put it on your office wall, or post it to your social media to show your accomplishment.
Prerequisites
A basic understanding of how to write a select statement, and knowledge of update and delete would be helpful. Access to a SQL Server environment where you can run queries would be helpful but not required.