不要一下子就for insert,update,delete
写成三个触发器
Create trigger dba.biao01_insert on dba.biao01 for insert
Create trigger dba.biao01_update on dba.biao01 for update
Create trigger dba.biao01_delete on dba.biao01 for delete
写成三个触发器
Create trigger dba.biao01_insert on dba.biao01 for insert
Create trigger dba.biao01_update on dba.biao01 for update
Create trigger dba.biao01_delete on dba.biao01 for delete
在for后面跟的是什么单词,就触发什么事件
insert 当插入时触发事件
update 当更新时触发事件
delete 当删除时触发事件
老兄你没看清我的问题啊!
我要一次for insert,update,delete
然后在触发器中用sql语句来判断是那种触发行为。
UPDATING //是更新
deleting是//删除
找到,给我一个[email protected]
FOR INSERT,UPDATE,DELETE
AS
BEGIN
DECLATE @i int,@j int
SELECT @i = COUNT(*) FROM INSERTED
SELECT @i = COUNT(*) FROM DELETED
IF @i = 0 --delete
.................
IF @j = 0 --insert
.................
IF @i<>0 AND @j<>0 --update
................
END