create trigger XXX
on 表
for update
as begin
update 表 set 字段=值 where ID=(SELECT d。ID fromINSERTED d )
end
create trigger tgr_name
on 表a
for insert
as
declare @id
select @id=id from inserted
update 表b
set State=0
where State=1 and id=@id
建立insert delete update 触发器时会有inserted ,deleted 临时表(update时两者都有)
通过他们执行执行相应的逻辑操作即可。
语法示例
create trigger TriTest
on TableA for insert
as
if exists (select ‘True’
from inserted
where inserted。ColA > 3
)
begin
update TableA
set ColB = 9
where 条件。
end
- 上一篇:“一贯道坛主”是什么意思?
- 下一篇:PSP联合突袭2全人物出现方法?