Trigger updating a field value of the updated reco

• PAUL717

  SSC-Addicted

  Points: 428

  More actions

  October 30, 2001 at 9:12 am

  #157586

  I'm trying to create a trigger that fires on update from a table.

  That would updated one column of the updated record.

  ex: On UPDATE the table OPERATIONS the trigger should update the value of the column UPDATES for the record that was just updated (with a where condition or someting like that)

  Is this possible?

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 30, 2001 at 10:45 am

  #419503

  Yes. You just use the inserted table to qualify which rows you want to update.

  Andy

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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736140

  More actions

  October 30, 2001 at 12:36 pm

  #419506

  You can also use UPDATED() to check if a specific column has changed.

  Steve Jones

  steve@dkranch.net