新手提：如何建的器！
有一表，在想在表新加一的候，能在一表把新加的添加去，除一的候，也能在另一表把除的添加去，表的都是一模一的，怎的器呢？

[解决办法]
假如有

t1

t2

t3

t1新增，同保存在t2表中
t1除，把除的保存在t3表中


create trigger tri_ins on t1
after insert
as
insert into t2
select * from inserted


--
create trigger tri_del on t1
after delete
as
insert into t3
select * from deleted



[解决办法]
create trigger tri_test
on [TableName]
for update,insert,delete
as
insert [Table] select * from inserted
insert [Table] select * from deleted