Update an entire single column with table joined query

This question already has an answer here:

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

---

UPDATE kg
 SET Kg.kioskName =  K.name
from KioskGoals kg inner join [TestDB].dbo.Kiosks k 
on kg.kioskID = k.Id

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

上一篇: 通过匹配ID更新另一个表中的行单元格

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