你试试: create trigger 名 on 你的表 for insert,update,delete as select * from inserted select * from deleted
create table aa (a int,b int) go create trigger 名 on aa for insert,update,delete as select * from inserted select * from deleted go ---这里你一句一句试! insert aa values(1,1) --insert aa values(2,2) --delete aa
create trigger 名 on 你的表 for
insert,update,delete
as
select * from inserted
select * from deleted
go
create trigger 名 on aa for
insert,update,delete
as
select * from inserted
select * from deleted
go
---这里你一句一句试!
insert aa values(1,1)
--insert aa values(2,2)
--delete aa
delete
as
delete 另一个表 where 编号 in(select 编号 from deleted)