插入更新触发器如何判断是插入还是更新 [英] Insert Update trigger how to determine if insert or update

问题描述

我需要在表 A 上编写一个插入、更新触发器，它将删除表 B 中的所有行，这些行的一列(比如 Desc)的值类似于在表 A 的列(比如 Col1)中插入/更新的值.我将如何编写它以便我可以处理更新和插入情况.我如何确定触发器是为更新还是插入执行的.

I need to write an Insert, Update Trigger on table A which will delete all rows from table B whose one column (say Desc) has values like the value inserted/updated in the table A's column (say Col1). How would I go around writing it so that I can handle both Update and Insert cases. How would I determine if the trigger is executed for an update or insert.

推荐答案

触发器有特殊的 INSERTED 和 DELETED 表来跟踪之前"和之后"数据.所以你可以使用类似 IF EXISTS (SELECT * FROM DELETED) 的东西来检测更新.更新时您只有 DELETED 中的行，但 INSERTED 中总是有行.

Triggers have special INSERTED and DELETED tables to track "before" and "after" data. So you can use something like IF EXISTS (SELECT * FROM DELETED) to detect an update. You only have rows in DELETED on update, but there are always rows in INSERTED.

寻找插入"在创建触发器中.

编辑，2011 年 11 月 23 日

Edit, 23 Nov 2011

评论后，此答案仅适用于 INSERTED 和 UPDATED 触发器.
显然，DELETE 触发器不能有INSERTED 中的总是行"；正如我上面所说的

After comment, this answer is only for INSERTED and UPDATED triggers.
Obviously, DELETE triggers can not have "always rows in INSERTED" as I said above

这篇关于插入更新触发器如何判断是插入还是更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！