create trigger trig_notic_UI
on notic for insert,update
as
update notic set memo=memo+'<dcboy>'
where id in(select id from inserted)
go
/*
trig_notic_UI 触发器名称 自定义
notic 需要触发的表名
memo 需要更新的字段
id 是主键
*/
on notic for insert,update
as
update notic set memo=memo+'<dcboy>'
where id in(select id from inserted)
go
/*
trig_notic_UI 触发器名称 自定义
notic 需要触发的表名
memo 需要更新的字段
id 是主键
*/