Trigger and number of rows affected

added by jacobsebastian
4/8/2011 3:04:40 AM

132 Views

One of my frieds told me that INSERT trigger will not fire if no data are added to the main table. It is a mistake that some people think that triggers will not fire if no row is affected. Note that trigger is event based and not data based. Here is a proof that trigger fires eventhough no row is affected...


0 comments