Introduction to DML Triggers : AFTER and INSTEAD OF - Video Series Video Category: Transact-SQL Basics: Queries, Stored Procedures, Functions and more Skill Level: 300 (Intermediate) Versions/Editions Covered: SQL Server - All Versions DML triggers are database objects that fire on a praticular operation for a particular table.In this essential 6-part series, your instructor will provide you with a great overview of how,when, and why to use the AFTER and INSTEAD OF triggers for SQL Server. Highlights from this series: What are the different types of triggers (DML vs DDL)? About the two types of DML triggers AFTER INSTEAD OF When will the two triggers fire? Similarities between Triggers and Stored Procedures Creating an audit trail trigger Example of when to use an AFTER trigger for a business rule What is a ghost/virtual delete? Using the UPDATE() function to audit specific info

Videos in this Series:

Title Skill Length Download Part 1 - An Introduction to DML Triggers - AFTER and INSTEAD OF Triggers   200 11 mins. Download Part 2 - More Detail on Using AFTER Triggers in SQL Server   200 10 mins. Download Part 3 - Building AFTER Triggers for Auditing Row Changes and Table Changes   300 11 mins. Download Part 4 - Building AFTER Triggers for Enforcing Advanced Business Rules   300 14 mins. Download Part 5 - INSTEAD OF Triggers and Ghost/Virtual Deletes   400 10 mins. Download Part 6 - The UPDATE() Function, Trigger Timing, and Final Summary   300 10 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

You can use the "SQL Server Web Data Adminstrator" to manage your SQL Server from the web. Check out Microsoft's Download page and search for "SQL Server Web Data Administrator" for more The command-line command "net" can be used to for many administrative tasks such as creating shares, creating mapped drives, and much more. Go to command-line, and execute the command "net help" for more details The TIMESTAMP data type name was replaced in Microsoft SQL Server 2000 by the ROWVERSION data type. They are the same; nothing changes but the name