如何一次更新字段查询？ [英] How to update field at once query?

问题描述

我有两个数据库orgindb和seconddb。在两个数据库中都有相同的字段表smcNo和shName字段。我想在smcNo的基础上更新与orgindb相同的seconddb的shName。我一个接一个地更新了很长时间。





请帮帮我。



我尝试过：

I have two database orgindb and seconddb. In both database have same fields tables smcNo and shName fields. I want to update the shName of seconddb same as orgindb on the base of smcNo. I update one by one it took long time.


Please help me.

What I have tried:

UPDATE seconddb.dbo.table2 
set seconddb.dbo.table2.shName = origindb.dbo.table1.shName
where seconddb.dbo.table2.smcNo = 'smc-0001'

推荐答案

正确的更新语句应如下所示：

A proper update statement should looks like:

UPDATE A SET A.shName = B.shName
FROM seconddb.dbo.table2 AS A
    INNER JOIN origindb.dbo.table1 AS B ON A.smcNo = B.smcNo
--WHERE A.smcNo = 'smc-0001'
--uncomment above line to update specific record

这篇关于如何一次更新字段查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！