12. Triggers and Audit Trail - Designing Database Solutions with Microsoft SQL Server 2022

In this lesson, Joed Goh explains the use of Triggers in Microsoft SQL Server. Triggers are commonly used to maintain data integrity, control server operations, or perform auditing tasks to strictly implement business rules. This lesson demonstrates how to create DML triggers to perform basic auditing actions on a table when DML commands such as INSERT, UPDATE, or DELETE operations are being performed. Table of Contents: 00:00 Introduction 01:14 AFTER Trigger (INSERT) 04:45 AFTER Trigger (DELETE) 05:41 AFTER Trigger (UPDATE) 07:36 The UPDATE() Function 10:35 INSTEAD OF Trigger (DELETE) PLAYLISTS: Designing Database Solutions with Microsoft SQL Server 2019    • Designing Database Solutions with Mic...   Artificial Intelligence and Machine Learning Foundations    • Artificial Intelligence and Machine L...   IoT Development    • Internet of Things   Android App Development in Kotlin    • Android App Development in Kotlin   Embedded Systems using Arduino Uno    • Embedded Systems using Arduino Uno   Data Structures and Algorithms using C#    • Data Structures and Algorithms  

• #education
• #trigger
• #audit_trail
• #logs
• #dml
• #insert
• #update
• #delete
• #instead_of
• #after_trigger
• #for_trigger
• #instead_of_trigger