--先添加字段--
alter table A
add ADDRESS varchar(100)--再插入--update A set ADDRESS=(select ADDRESS from B where ID=A.ID)
alter table A
add ADDRESS varchar(100)--再插入--update A set ADDRESS=(select ADDRESS from B where ID=A.ID)
goupdate a set address=b.address from b
where a.id=b.id
go
update A set A.address=a.address from B a where a.ID=A.ID
add ADDRESS varchar(100)
update A set ADDRESS=(select ADDRESS from B where B.ID=A.ID)