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

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • 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 2 (of 2 total)

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