触发器AFTER及FOR的区别

最新推荐文章于 2023-02-15 00:19:48 发布

weixin_30270889

最新推荐文章于 2023-02-15 00:19:48 发布

阅读量1.3k

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 c#

原文链接：http://www.cnblogs.com/cnaspnet/archive/2009/10/29/1592365.html

本文详细介绍了数据库中AFTER和INSTEAD OF两种触发器的区别及使用场景。AFTER触发器在触发SQL语句成功执行后激活，而INSTEAD OF触发器则替代触发SQL语句执行。此外还讨论了这两种触发器在视图上的限制。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

AFTER
Specifies that the DML trigger is fired only when all operations specified in the triggering SQL statement have executed successfully. All referential cascade actions and constraint checks also must succeed before this trigger fires.
AFTER is the default when FOR is the only keyword specified.
AFTER triggers cannot be defined on views.
INSTEAD OF
Specifies that the DML trigger is executed instead of the triggering SQL statement, therefore, overriding the actions of the triggering statements. INSTEAD OF cannot be specified for DDL triggers.
At most, one INSTEAD OF trigger per INSERT, UPDATE, or DELETE statement can be defined on a table or view. However, you can define views on views where each view has its own INSTEAD OF trigger.
INSTEAD OF triggers are not allowed on updatable views that use WITH CHECK OPTION. SQL Server raises an error when an INSTEAD OF trigger is added to an updatable view WITH CHECK OPTION specified. The user must remove that option by using ALTER VIEW before defining the INSTEAD OF trigger.

转载于:https://www.cnblogs.com/cnaspnet/archive/2009/10/29/1592365.html