Trigger with where clause

• Uroc

  SSC Journeyman

  Points: 95

  More actions

  February 29, 2008 at 8:31 am

  #187167

  One week ago I wrote my first stored procedure. Since, that time I have made great progress normalizing a legacy system in SQL Express and have found it extremely interesting. As for the triggers, I have created a log table that has a trigger on it. Now, I can have the trigger fire if a certain field is updated. Is it possible to have the trigger fire, if the field is updated to a certain value.

  Thanks for any help

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  February 29, 2008 at 8:40 am

  #783829

  Sure ....

  IF (SELECT 1 FROM inserted WHERE yourField = 'yourTestValue')

  BEGIN

  -- your trigger code here

  END

  ______________________________________________________________________

  Personal Motto: Why push the envelope when you can just open it?

  If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

  Jason L. Selburg

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  February 29, 2008 at 8:42 am

  #783832

  Sure ....

  IF EXISTS (SELECT 1 FROM inserted WHERE yourField = 'yourTestValue')

  BEGIN

  -- your trigger code here

  END

  OPPS... EDITED!! I forgot ot add the EXISTS keyword

  ______________________________________________________________________

  Personal Motto: Why push the envelope when you can just open it?

  If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

  Jason L. Selburg

• Uroc

  SSC Journeyman

  Points: 95

  More actions

  February 29, 2008 at 9:01 am

  #783863

  Genius.....

  Thanks man.....