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
https://youtube.com/playlist?list=PLVTsfY7Kr9qjagmWoPLXPvdOk46C5IAB_

Artificial Intelligence and Machine Learning Foundations
https://youtube.com/playlist?list=PLVTsfY7Kr9qjMqXcOUEkB_rDHQVTVDYtY

IoT Development
https://www.youtube.com/playlist?list=PLVTsfY7Kr9qjVkq8aJmTXbiiy5h41ayRL

Android App Development in Kotlin
https://youtube.com/playlist?list=PLVTsfY7Kr9qimoaNmBCQQcvNi49EoKTWS

Embedded Systems using Arduino Uno
https://youtube.com/playlist?list=PLVTsfY7Kr9qhkfmq85MH2xObFIELuq_Vo

Data Structures and Algorithms using C#
https://youtube.com/playlist?list=PLVTsfY7Kr9qiTxECmzTVkLZt1DkaFEfUg