Post reply

Update Trigger on specific row

  • June 20, 2005 at 3:33 am

    #87766

    Hi

    I'm trying to get a trigger set up to update a second table when any row in a first table is updated, but only want to update the specific row into the second table. Is there a property I can call / reference that will return which row the update occurred at?

    Thanks

    Joshua

  • June 20, 2005 at 4:18 am

    #566664

    Check out BOL "Using the inserted and deleted tables" for more info.  To summarise, the 'inserted' table is a temporary table that contains a copy of the record (or records) that have been inserted or updated.  Query this table within the trigger to determine which rows to insert into your second table.

    Regards

  • June 20, 2005 at 4:46 am

    #566665

    Hi Phil,

    Thanks for the response.

    BOL = Books On Line, right? I'm searching them now. Thanks.

    Perfect. Exactly what I need.

    Thanks!

    Joshua

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply