In this tutorial, you will learn complete detail about the triggers in SQL Server 2019. We will cover the DDL trigger and DML trigger in detail with detailed examples.
0:5 What we are going to learn in this tutorial
0:39 What is Trigger in SQL Server
0:54 What are events in SQL Server and how the trigger is an eventdriven program
1:04 DML and DDL Events
2:06 DML Trigger example in SQL Server
2:34 Trigger on Insert Event in SQL Server
8:12 Trigger example for Delete event in SQL Server
9:52 DDL Trigger example in SQL Server
11:06 where to find existing triggers in SQL Server
11:52 How to get the list of triggers available
12:11 How to modify the definition of existing Trigger in SQL Server
12:21 How to get the definition of triggers
13:02 How to disable and enable triggers in SQL Server
13:24 How to drop triggers in SQL Server
For more details please visit:
GetsetSQL Blog: www.getsetsql.com
YouTube Channel: / getsetsql
Facebook: / getsetsql
Quora: http://www.quora.com/AmiteshBi/
Twitter: / getsetsql
Twitter: / amiteshdba
LinkedIn Group: / 10541375
LinkedIn Profile: / amiteshsrivastava
#sqlservertrigger #sqlservertriggers #triggers #SQLServer