sql server触发器中增删改判断

触发器生效逻辑

在Before或者After之后使用INSERT,DELETE,UPDATE

触发器内情况判断

  • 插入
    if exists(select 1 from inserted) and not exists(select 1 from deleted)
  • 删除
    ELSE if exists(select 1 from deleted) and not exists(select 1 from inserted)
  • 更新
    ELSE if exists(select 1 from deleted) and exists(select 1 from inserted)

posted on 2015-07-06 22:54  camash  阅读(1355)  评论(0)  编辑  收藏  举报

导航