求一个触发器写法,先谢谢大家了,
有a,b,两个表,结构完成相同,当删除a表中记录时,会将在b表中追加这条被删除的记录

[解决办法]
CREATE TRIGGER my_trig ON a FOR DELETE
AS
insert into b select * from deleted
GO