CREATE TRIGGER 触发器名 ON 表 FOR INSERT AS delete 表 from inserted aa where aa.编号=表.编号 and 列=0
如果是两种行为(insert,update)的触发呢? 分别写?
CREATE TRIGGER 触发器名 ON 表 FOR INSERT,update AS delete 表 from inserted aa where aa.编号=表.编号 and 列=0
不!我上面写错了!你update想得到什么效果???CREATE TRIGGER 触发器名 ON 表 FOR INSERT AS delete 表 from inserted aa where aa.编号=表.编号 and 列=0 goCREATE TRIGGER 触发器名 ON 表 FOR update AS update 表 set 列=aa.列 from deleted aa where aa.编号=表.编号----------------------------------------------------------- 右键你的表-->所有任务-->管理触发器
FOR INSERT
AS
delete 表 from inserted aa where aa.编号=表.编号 and 列=0
FOR INSERT,update
AS
delete 表 from inserted aa where aa.编号=表.编号 and 列=0
FOR INSERT
AS
delete 表 from inserted aa where aa.编号=表.编号 and 列=0
goCREATE TRIGGER 触发器名 ON 表
FOR update
AS
update 表 set 列=aa.列 from deleted aa where aa.编号=表.编号-----------------------------------------------------------
右键你的表-->所有任务-->管理触发器