Triggers and Stored Procedure

Results 1 to 2 of 2

Thread: Triggers and Stored Procedure

  1. #1
    Join Date
    Dec 1969

    Default Triggers and Stored Procedure

    I need to create a trigger. The trigger needs to fire after an insert and update one field. Is it possible to catch the field that was inserted to only affect it with an update statement. I also plan on doing another trigger that will fire a stored procedure, but I also need to capture the id of the inserted item.<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default sure........why not

    jsut dont see WHY you would need a trigger<BR><BR><BR>But select whatever from inserted<BR><BR><BR>inserted will be the record that was inserted/updated<BR><BR><BR>

Posting Permissions

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