Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    2

    Unanswered: trigger in sql server 2000

    How can I fire a procedure when a field is less than a threshold in sql server 2000?

    Have you got any idea or suggestion?

    Thanks in advance,
    Andrea

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Look up CREATE TRIGGER and pay particular attention to the INSERTED table that is available within the scope of a trigger

    Triggers fire on INSERT, UPDATE & DELETE actions only. Within each action you can test the values needed by looking at the contents of the INSERTED and DELETED tables.
    George
    Home | Blog

Posting Permissions

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