New SQL Server Video Tutorial: Part 4 - Building AFTER Triggers for Enforcing Advanced Business Rules

Part 4 - Building AFTER Triggers for Enforcing Advanced Business Rules - view details

If you can't use a constraint to enforce/perform business rules, then the AFTER trigger is what you'll need to employ! In this fourth video in the series Scott will walk you�� throw the process of how to build an AFTER trigger that will enforce advanced business rules.

Highlights from this video:

• Example of when to use an AFTER trigger for a business rule
  
• Raising an error when trigger is fired for business rule
  

and much more

---

• Source: http://www.learnsqlserver.com
• Category: Transact-SQL Basics: Queries, Stored Procedures, Functions and more
• Skill Level: 300 (Intermediate)
• Length: 13:45 (13.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, build trigger, business rule, create trigger