post icon

MS SQL Server Update multiple table

Table A will be updated with data from Table B

UPDATE A
    SET A.NAME = B.NAME
FROM TableNameA A, TableNameB B
WHERE A.ID = B.ID

Comments are closed.

Leave a comment