Home Forums SQL Server 2005 Development Evaluate each field from source to target and update RE: Evaluate each field from source to target and update

  • October 14, 2016 at 4:22 am

    #1906523

    hegdesuchi (10/13/2016)

    Hi,

    We cannot have hash because target table does not have it. we cannot alter the target table.

    Can we do this by dynamic updates?

    i.e. I want to check if any column has changes in target , update only those columns in target . can we do this dynamically?

    Create a hash in your select on both sides. Then compare the 2 hashes.

    How to post data/code on a forum to get the best help.