retrieve data when a trigger is being executed

• Sreevani

  Newbie

  Points: 1

  More actions

  May 25, 2002 at 4:03 am

  #357540

  How do we retrieve the contents of a row modified when a corresponding col is changed

  in an update trigger

• ramakrishna100

  SSC Veteran

  Points: 216

  More actions

  May 25, 2002 at 5:04 am

  #429765

  Hi Sreevani

  If you are modifing a record, first Sql server delets the record and then insert a new record with the modified value. Here the deleted table contains the old values and inserted table contains the new values. Further information like how to use and all you can get from SQL Server help.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738347

  More actions

  May 25, 2002 at 11:56 am

  #429766

  Inside the trigger, you can select * from inserted to see the new values, select * from deleted to see the old. You can compare these, join the tables, even join with the modified table to manipulate the data.

  Steve Jones

  steve@dkranch.net