INF: Example of Using Nested Triggers

ID: Q79886

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2

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)

   /* (select count(*) from inserted) */ 
       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.

Keywords : kbother SSrvServer
Version : 4.2
Platform : OS/2
Issue type :