Results 1 to 2 of 2

Thread: Trigger

  1. #1
    Join Date
    Apr 2004
    Location
    Italy
    Posts
    7

    Unanswered: Trigger

    Hello to all,

    how can I check a field value into a trigger?

    On the trigger I wanna copy a record only if a specific field has the value 1.
    The field is contained on the record.

    Thank you

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Look up the virtual tables "Inserted" and "Deleted" in Books Online.
    These contain copies of the records being modified, and can be referenced inside of triggers.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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