Q&A for professional robotic engineers, hobbyists, researchers and students
create table #A(ID int, value varchar) create table #B(ID int, value varchar) insert into #A values (1,'A'), (2,'A'), (3,'D') insert into #B values (1,'C'), (2,'D') UPDATE #A SET #A.Value = #B.Value FROM #B WHERE #A.ID = #B.ID AND #A.Value <> #B.Value SELECT * FROM #A