Update trigger

• Pedro Estrada

  Old Hand

  Points: 357

  More actions

  June 8, 2002 at 8:38 am

  #78774

  Hi all,

  I am trying to write a trigger that updates a column of the record being updated in the same table, I know the trigger will fire again on that update but my question is, is there a way of detecting this updated column and do nothing so it will not fire again?

  TIA

  JW

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  June 8, 2002 at 9:07 am

  #430547

  That will happen automatically unless you enable recursive triggers, which is disabled by default and not likely to be needed!

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter