sizal0234
SSCrazy
Points: 2272
More actions
January 22, 2020 at 9:11 pm
#3717567
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!
ScottPletcher
SSC Guru
Points: 100911
January 22, 2020 at 10:19 pm
#3717584
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