Sql Update Query

This question already has an answer here:

How do I UPDATE from a SELECT in SQL Server? 27 answers

---

怎么样

UPDATE T1
SET Address = T2.New_Address
FROM T2
WHERE T1.id = T2.id

---

UPDATE T1
SET T1.Address = T2.New_Address
FROM T1
INNER JOIN T2 ON T2.ID = T1.ID

---

UPDATE T1
SET Address = (select New_Address from T2 where T1.ID=T2.ID );

链接地址: http://www.djcxy.com/p/16856.html

上一篇: 使用表连接查询更新整个单列

下一篇: Sql更新查询