This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 46%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
is trigger fire in the same order in which sequence it was created for a table without setting the order?
If you have several triggers trigger on a table (no good design), then you can only define the first and the last trigger to run, all other will be executed by random.
See CREATE TRIGGER (Transact-SQL) => Remarks for DML Triggers
Hi Olaf,
I created 3 triggers (trigger1, trigger2, trigger3) for update action on a table.
But I created these trigger in sequence trigger2, trigger1,trigger3, then I updated one record of table and observed triggers were fired in same sequence trigger2, trigger1,trigger3.
could you please share your thought on it.
Olaf said "random". That is not really accurate. More accurate is "indeterministic" or "arbitrary". As long as nothing changes, you are likely to see the same order, but it is nothing you can rely on.