CREATE TRIGGER DelNode ON codedata
FOR DELETE
ASselect id from
delete from pminformation
from pminformation a,
(select id from deleted) b
where a.code_ID=b.id你试试对不对?
FOR DELETE
ASselect id from
delete from pminformation
from pminformation a,
(select id from deleted) b
where a.code_ID=b.id你试试对不对?
FOR DELETE
ASdelete from pminformation
from pminformation a,
(select id from deleted) b
where a.code_ID=b.id上面的多了一句话.
delete p from pminformation as p inner join deleted as d on p.code_id=d.id
CREATE TRIGGER DelNode ON codedata
FOR DELETE
AS
delete from codedata where id_parent in(select id from deleted)
Delete From pminformation where code_ID in (select id from deleted)