--TR1和TR2搞反了CREATE TRIGGER TR_TR1 ON TR1 FOR INSERT AS INSERT INTO TR2 ( ID, AGE ) SELECT ID, AGE FROM INSERTED
create trigger udt_tr1i on tr1 for insert as begin insert into tr2 select id , age from inserted if @@error <> 0 begin raiserror('insert error' , 16 , 1) rollback end end
ON TR1 FOR INSERT
AS
INSERT INTO TR2
(
ID, AGE
)
SELECT
ID, AGE
FROM
INSERTED
create trigger udt_tr1i
on tr1
for insert
as
begin
insert into tr2
select id , age from inserted if @@error <> 0
begin
raiserror('insert error' , 16 , 1)
rollback
end
end