create proc p_delrecord
as
delete from table3 where id in (select id from yourtable where 条件) --符合一条记录
delete from table2 where id in (select id from yourtable where 条件) --符合一条记录
....
delete from yourtable where 条件 --删除此数据记录
CREATE TRIGGER 名 on c
INSTEAD OF delete
AS
BEGIN
delete a where 主键 in (select 主键 from deleted)
delete b where 主键 in (select 主键 from deleted)
delete c where 主键 in (select 主键 from deleted)
END