Trigger for only updating specific column

  • Hi,

    using Merge I can sync table A with Table B at ROW level. However 'how to update only specific column instead of the whole row'?

    Sincerely!

     

  • In the WHEN MATCHED part of the MERGE, specify only the columns you want UPDATEd.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

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

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