大概思路如下:CREATE TRIGGER tr_tesrON tb_1FOR INSERT, DELETEAS IF NOT EXISTS (SELECT 1 FROM DELETED) --tb_1插入时BEGIN
INSERT INTO tb_2(字段列表)
select 字段列表 from insertedENDIF NOT EXISTS (SELECT 1 FROM INSERTED) --tb_1删除时BEGIN
DELETE a fromtb_2 a,deleted b where a.关联字段=b.关联字段 ENDGO
