ID Number: Q79886
4.20
OS/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.
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.
Additional reference words: 4.20