create table trig1 ( id int identity(1,1), name varchar(50) ) go create table trig2 ( id int identity(1,1), name varchar(50) ) go
--插入 trig1 同时插入 trig2 create trigger trig1_insert on trig1 for insert as begin insert into trig2 values('trig1_insert') print 'trig1_insert' end go
--插入 trig2 同时插入 trig1 create trigger trig2_insert on trig2 for insert as begin insert into trig1 values('trig2_insert') print 'ttrig2_insert' end go insert into trig1 values('10') ------------------------------
本帖最后由 roy_88 于 2011-08-11 17:57:35 编辑
USE tempdb GO CREATE PROC P_Tree AS EXEC P_tree GO EXEC P_tree
(
id int identity(1,1),
name varchar(50)
)
go
create table trig2
(
id int identity(1,1),
name varchar(50)
)
go
--插入 trig1 同时插入 trig2
create trigger trig1_insert
on trig1
for insert
as
begin
insert into trig2 values('trig1_insert')
print 'trig1_insert'
end
go
--插入 trig2 同时插入 trig1
create trigger trig2_insert
on trig2
for insert
as
begin
insert into trig1 values('trig2_insert')
print 'ttrig2_insert'
end
go
insert into trig1 values('10')
------------------------------
GO
CREATE PROC P_Tree
AS
EXEC P_tree
GO
EXEC P_tree