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
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.