更新表A中某列为表B中的值
update Table
set Name='lchen'
from Table
where ID=123
更新表A中某列为表B中的值
update TableA
set Name = TableB.OldName, Sex = TableB.Sex
from TableA, TableB
where TableA.Name = TableB.Name;
更新表A中某列为表B中的值
当A = B 时
update A
set A.Name = B.OldName, A.Sex = B.Sex
from Table A, Table B
where A.Name = B.Name;