如果SQL Server中的事务失败，触发器是否会回滚？ [英] Do triggers get rolled back if a transaction fails in SQL Server?

问题描述

在某些表上有一些触发器，当某些东西被删除或更新时它们会执行一个功能。在事务期间，如果执行触发器，然后在事务中稍后将其回滚，那么触发器也会回滚吗？

I have some triggers on some tables that perform a function when something is deleted or updated. During a transaction, if the trigger executes and later in the transaction it gets rolled back, does the trigger also get rolled back?

推荐答案

是的。

只要触发器作为事务的一部分触发，数据库中make的任何更改也会被回滚。

So long as the trigger fires as part of the transaction, any changes in makes within the database would also get rolled back.

Nitpick-触发器是触发器，它不会回滚。触发器的效果为。

Nitpick - a trigger is a trigger, it will not get rolled back. The effects of the trigger will be.

这篇关于如果SQL Server中的事务失败，触发器是否会回滚？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！