New SQL Server Video Tutorial: Part 1 - An Introduction to DML Triggers - AFTER and INSTEAD OF Triggers

Part 1 - An Introduction to DML Triggers - AFTER and INSTEAD OF Triggers - view details

DML triggers are database objects that fire on a praticular operation for a particular table. In this first video in the 6-part series, your instructor Scott will begin by giving you a great overview of the DML triggers AFTER and INSTEAD OF by taking you through the process of building the table with which the triggers will work as well as fire the trigger. Included with this video tutorial is Scott's SQL Script!

Highlights from this video:

• What are the different types of triggers?
  
• Real-world example of triggers
  
• What does it mean when a trigger fires and when do they fire?
  

and much more

---

• Source: http://www.learnsqlserver.com
• Category: Transact-SQL Basics: Queries, Stored Procedures, Functions and more
• Skill Level: 200 (Beginner - Intermediate)
• Length: 10:45 (10.5MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: trigger, dml, AFTER, INSTEAD OF,