SQL table update

Question

Hema Ramachandran 176

I have two tables:

I want to update Table1 with Table2 data based on ID

Answer accepted by question author

1 additional answer

Answer 1

Hema Ramachandran 176

I found the answer.

UPDATE T1
SET Name= T2.Name
FROM Table1 AS T1
INNER JOIN
Table2 AS T
ON T1.ID = T2.ID and T1.Name<> T2.Name

Answer 2

Olaf Helper 47,581

Then do it; where is the problem?

UPDATE T1
SET Column = T2.OtherColumn
FROM Table1 AS T1
     INNER JOIN
     Table2 AS T
    ON T1.ID = T2.ID

Hema Ramachandran 176 Reputation points

2021-11-12T10:45:05.617+00:00

Your query will update all the rows. I want to update only the records where the name columns is different.
Olaf Helper 47,581 Reputation points

2021-11-12T12:43:03.593+00:00

I want to update only the records where the name columns is different.

You didn' wrote that before; so how could I guess that?