New SQL Server Video Tutorial: Part 5 - INSTEAD OF Triggers and Ghost/Virtual Deletes

Part 5 - INSTEAD OF Triggers and Ghost/Virtual Deletes - view details

This fifth video in the series will now focus on the INSTEAD OF trigger and the trigger's functionality to carry out virtual/ghost deletes. Included with this video download is Scott's SQL Script

Highlights from this video:

• Working with a Many-to-Many relationship
• Adding a Discontinued column to delete a product
  
• What is a ghost/virtual delete?
  
• Working with ghost deletes
  

and much more

---

• Source: http://www.learnsqlserver.com
• Category: Transact-SQL Basics: Queries, Stored Procedures, Functions and more
• Skill Level: 400 (Intermediate - Advanced)
• Length: 10:15 (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, ghost delete, virtual delete