What is Recursive Triggers? If a trigger defined in the Table1 modifies data in the Table2 table, and the Table2 has a trigger that in turn modifies the Table1, the trigger defined in the Table1 will fire again.This situation is called indirect recursion. It is possible to a single statement forces multiple executions of the [...]
Archive for the ‘Triggers’ Category
Recursive Triggers
Posted in Triggers on August 12, 2009 | Leave a Comment »
Nesting Triggers
Posted in Triggers on August 12, 2009 | Leave a Comment »
Whats mean by nesting triggers ? If a trigger is force to execute other trigger and that trigger is force some other triggers then this action is called “Nesting Triggers”. Properties: This execution stops when the last action does not fire any more triggers. Because triggers are a specialized form of stored procedures. You can [...]
