更新的触发器，更新自己的表，还记得触发器吗?

I have a table called Point. The table has two columns that we'll deal with, ActualDepth and DesignDepth. When someone updates ActualDepth I have a trigger that will recalculate the DesignDepths for all of the other points that are near the updated one.

我有一张叫Point的表格。该表有两列，我们将处理，实际深度和设计深度。当有人更新实际深度时，我有一个触发器，它将重新计算在更新深度附近的所有其他点的设计深度。

My question then is, Will my trigger be called recursively because other rows in the same table have been updated? Or, will the fact that the update is happening in a trigger be enough to stop it. This is the behaviour that I want.

我的问题是，我的触发器会因为同一个表中的其他行被更新而被递归调用吗?或者，更新发生在触发器中的事实是否足以阻止它。这就是我想要的行为。

1 个解决方案

#1

Depends if the system wide option "recursive triggers" is turned on. It's off by default.

取决于系统宽选项“递归触发器”是否打开。这是默认关闭的。