MS SQL Server :: DML Triggers (Insert, Update & Delete)
To download a copy of the script used in this video, please visit:
https://github.com/WallyPons/YouTube
Chapters:
00:00 Intro
00:39 Initial Scripts
01:52 The "Person" Table
02:13 The "Trigger Watch" Table
03:13 Insert Trigger
05:35 Update Trigger
06:29 Delete Trigger
07:17 List Triggers
08:00 Contents of "Person" and "Trigger Watch" Tables
08:21 Insert One Record Into "Person" Table
08:56 Verify "Trigger Watch" Table For Insert
10:26 Update "DateOfBirth" From "Person" Table
11:11 Verify "Trigger Watch" Table For Update
11:42 Delete a Record From "Person" Table
12:15 Verify "Trigger Watch" Table For Delete
12:41 Why Use "Trigger Watch" Table
13:10 Outro
Would you like to hire me for your SQL questions and solutions?: https://www.fiverr.com/s/e6ALv5E
I've worked across SQL Server, MySQL, and PostgreSQL, supporting both small businesses and
enterprise-level environments. Whether it's a one-time fix or ongoing support, I'll bring
clarity, reliability, and efficiency to your data.
Your database problems don't have to slow you down, let's solve them together!