Does a trigger on update, that updates its own table, recall the trigger?
Depends if the system wide option "recursive triggers" is turned on. It's off by default.
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.
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.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
Title: UPDATE is not allowed because the statement updates view “table_name” which participates in a join and has an INSTEAD OF UPDATE trigger?
MySQL trigger cannot update table : already in use by the statement that invoked the trigger?
How to tell NHibernate that a trigger updates another table?
Trying to figure out how Twitter's status updates is different from Facebook status updates...Answers?
I get sent Askville activity updates. Do people find the activity updates via email to be useful?
My hard drive in filling up and a lot of old updates. Can I delete the old updates on programs I rarely/never use?