如果 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屋！