update insert delete trigger - how to determine which action caused the trigger

update insert delete trigger - how to determine which action caused the trigger

Post by Hugo Korne » Thu, 07 Feb 2008 08:33:40



Hi mordgellis,

In addition to the answers you already have - if you find that insert,
update, and delete require different actions from the trigger, it is
*usually* far better to use three triggers and accept that some code
gets duplicated.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://www.yqcomputer.com/