June 4, 2003 at 12:55 pm
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.
June 4, 2003 at 2:21 pm
Could you provide a generic example of what you are trying to accomplish? I'm not following what you mean by:
<b>
Is it possible to catch the field that was inserted to only affect it with an update statement
</b>
Darren
Darren
June 4, 2003 at 2:29 pm
Thanks I have found what I need with the @@identity
Thank you for your help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply