CREATE TRIGGER TRI_NEWSSUBJECT_DELETE
ON NEWSSUBJECT
AFTER DELETE
as
BEGIN
delete newsview from deleted a where newsview.id=a.nbid
and newsview.subjectid=a.subjectid
END
ON NEWSSUBJECT
AFTER DELETE
as
BEGIN
delete newsview from deleted a where newsview.id=a.nbid
and newsview.subjectid=a.subjectid
END
-------------------------------------------
after delete是删除以后触发的,
for delete是删除以前触发的