Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    34

    Lightbulb Unanswered: Update Trigger - old value

    Is there a way I can get the old value of a specific field when using an update trigger?
    e.g. I want to use the condition 'If Update(Column) '
    in odrer to create a logfile which stores the old and new value of a field.
    The new value can be get from a Select from Inserted table.
    Is there a way I can get the old value (before update) also??

    Regards,
    Manolis

  2. #2
    Join Date
    Sep 2005
    Posts
    161
    The old value can be selected from the deleted table.

    insert into sometable
    select * from deleted

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •