象这样的DELETE的触发器其实都可以按照下面的写法直接写,不用那么复杂。CREATE TRIGGER ToDelnj
ON t_nj
FOR DELETE
AS
DELETE t_zy
FROM DELETED d INNER JOIN t_zy ON d.njID = t_zy.njID另外一个也可以照着写。
ON t_nj
FOR DELETE
AS
DELETE t_zy
FROM DELETED d INNER JOIN t_zy ON d.njID = t_zy.njID另外一个也可以照着写。
From Deleted Inner Join t_zy on t_zy.njID = Deleted.njID
insert:inserted
delete:deleted
update:inserted & deleted
deleted表和inserted表是逻辑表,总是在内存中,并不在硬盘上存放。
我是这样理解的,deleted表或inserted表在触发器执行时建立,在执行完毕后就会被释放掉,不知道对不对。
把 DELETE t_zy
FROM #temp_db d INNER JOIN t_zy ON d.njID = t_zy.njID
放到存储过程里执行。
我自己没试过,不知道这样行不行。