Using the TSQL Output Clause

The SQL Server Output Clause is a powerful feature for retrieving data from INSERT, UPDATE, or DELETE statements. This class will show you how to leverage the Output Clause for auditing, tracking changes, and creating an undo mechanism. An often overlooked feature, it can significantly enhance your ability to write effective queries.

Watch this video by Steve Stedman to find out more.

For additional informative videos, visit my YouTube channel at https://www.youtube.com/@SteveStedman. There, you’ll find a wide range of content covering various topics, all designed to provide valuable insights and help you stay informed.

Course Highlights:

Learn how to use the Output Clause in your INSERT, UPDATE, and DELETE statements.
Understand practical applications for auditing and change tracking.
Gain insights into capturing changes for undo operations.

What Students Are Saying:

“The Output Clause was ‘new’ knowledge for me. I never used or researched it before, but now I use it multiple times per day.”
— George (Course Student)

“I watched the whole course. Really great lesson.”
— Mo

Enroll Now:

This focused course is part of our SQL Short Courses series, designed to be highly targeted and value-priced. Completing this course will earn you a certificate to display your new skills proudly.

What You Are Getting:

Detailed lessons on using the Output Clause.
Practical examples and homework to reinforce learning.
A certificate of completion to showcase your achievement.

Prerequisites:

Basic knowledge of SELECT, UPDATE, and DELETE statements.
Access to a SQL Server environment for hands-on practice (helpful but not required).

Course Lessons:

Introduction
- Output Clause Course Introduction (3:00)
Output Clause Overview
Sample Code
Output with Insert Statements
- Output with Insert Statements (12:42)
- Homework for Insert Statements
Output with Update Statements
- Output with Update Statements (7:54)
- Homework for Update Statements
Output with Delete Statements
- Output with Delete Statements (4:58)
- Homework for Delete Statements
Archiving: Delete with Output
- Archiving: Delete with Output (8:46)
Review – Wrap Up
- Review (4:08)
- Output Clause Summary
Course Completion Certificate
- Course Completion Certificate (1:23)