New SQL Server Video Tutorial: Part 2 - More Detail on Using AFTER Triggers in SQL Server

Part 2 - More Detail on Using AFTER Triggers in SQL Server - view details

In this second video in the series, Scott will focus on the usage of the AFTER trigger, while still giving some basic information about the INSTEAD OF trigger. Scott will demonstrate some of the essential keys to using the AFTER trigger like when to use it, and what it's purpose is. Also included with the video is Scott's SQL Script!

Highlights from this video:

• About the two types of DML triggers
• AFTER
• INSTEAD OF
  
• When will the two triggers fire?
  
• Purpose of the AFTER trigger
  
• How to drop a trigger
  

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:00 (9.0MB)
• 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,