触发器问题

Question

更正：
应该是delete from tblTable2 where id= @key1
delete from tblTable3 where id = @key2

Answer 1

Tregger_Delete_Table2:
delete a from tblTable3 a join delted b on a.id = b.key2

Answer 2

create trigger trigger on table2 for delete
as
delete from table3 where [id] in (select [id] from deleted)

Answer 3

你的设计方法不对,改成下面的这个就行了.
create trigger Tregger_Delete_Table1 on Table1
for delete
as
delete from tblTable2
  where id in(select key1 from deleted)  --如果两表的关联字段是id,就将key1改为idcreate trigger Tregger_Delete_Table2 on Tables
for delete
as
delete from tblTable3
  where id in(select key1 from deleted)  --如果两表的关联字段是id,就将key1改为id