Senator Guerra Souty original series calendar,replica hublot blue steel peach pointer collocation of rolex replica Rome digital scale, track type minute replica watches scale shows that the classical model is swiss replica watches incomparable, wearing elegant dress highlights.
mr-ponna.com

 

YOU ARE HERE: HOME Questions I had created two update triggers for two columns in a table When i use update statement on this



SQL Server triggers execution precedence

View(s): 14512

I had created two update triggers for two columns in a table. When i use update statement on this table on which order or precedence trigger will fires?

Answer 1)
There is no guarantee as to what order they'll fire in. 

But still you can use sp_settriggerorder to define the first and last trigger to execute. For the rest the order is undefined. If precedence is matters to you then put all the logic in one trigger.

  Asked in:  TCS (Tata Consultancy Services)   Expertise Level:  Experienced
  Last updated on Sunday, 23 October 2011
4/5 stars (12 vote(s))

Register Login Ask Us Write to Us Help