如何一次更新字段查询? [英] 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屋!
查看全文