Thank this author by sharing:
By Andy Warren,
If you have never used an instead of trigger, it's a great mechanism for evading table triggers in certain situations. MVP Andy Warren brings you part one of this SQL School video.
Please be aware that you'll need to have the Adobe Flash Player 9 Plug-in installed to watch this video.
Runtime: 1:59 minutes
These videos are provided by JumpstartTV and End to End Training