CREATE OR REPLACE TRIGGER AddArticleCount
AFTER INSERT ON article_column
FOR EACH ROW
BEGIN
update columns set articlecount = articlecount + 1 where id =:NEW.column_id ;
END;
AFTER INSERT ON article_column
FOR EACH ROW
BEGIN
update columns set articlecount = articlecount + 1 where id =:NEW.column_id ;
END;
CREATE TRIGGER [SubtractArticleCount] ON dbo.article_column
FOR DELETE
AS
update [columns] set articlecount = articlecount - 1 where id in (select column_id from deleted)
是不是为:
CREATE OR REPLACE TRIGGER AddArticleCount
AFTER INSERT ON article_column
FOR EACH ROW
BEGIN
update columns set articlecount = articlecount - 1 where id =:OLD.column_id ;
END;
改用before delete应该就可以了!呵呵