INF: Example of Using Nested Triggers (79886)

SUMMARY

The following script shows the use of nested triggers. The output shows how the inner trigger is completed before the calling trigger is completed.

MORE INFORMATION

Script

use pubs
      go

      create table t1(a int)
      go
      create table t2(a int)
      go
      create trigger t1it on t1 for insert as
          print 'begin t1it'
          insert t2 values(1)
          print 'end   t1it'
      go

      create trigger t2it on t2 for insert as
          print 'begin t2it'
          print 'end   t2it'
      go

      insert t1 values (1)
      go

Output

begin t1it
begin t2it
end   t2it
end   t1it
(1 row affected)

NOTE: If triggers are nested such that a circular link is formed, an error message will be returned indicating that the maximum nesting level has been exceeded.