UPDATE TAB1
SET NAME = TAB2.ADDRESS,
AGE = TAB2.WEIGHT
FROM TAB2
WHERE TAB1.ID = TAB2.ID


好像只有M$ SQL Server支持