CREATE TRIGGER [TRIGGER NAME] ON [TABLE_q] FOR DELETE AS delete from tablev where tablev.ID=deleted.ID1.难道你的触发器就叫[TRIGGER NAME] ?? 2.tablev.ID=deleted.ID这里有错! 改成:CREATE TRIGGER yourtri ON [TABLE_q] FOR DELETE AS delete from tablev where tablev.ID=(select id from deleted)
应该这样写: delete tablev from tablev t1,deleted t2 where t1.id=t2.id
FOR DELETE
AS
delete from tablev where tablev.ID=deleted.ID1.难道你的触发器就叫[TRIGGER NAME] ??
2.tablev.ID=deleted.ID这里有错!
改成:CREATE TRIGGER yourtri ON [TABLE_q]
FOR DELETE
AS
delete from tablev where tablev.ID=(select id from deleted)
delete tablev from tablev t1,deleted t2 where t1.id=t2.id