让我们保持简短而甜蜜
我想这样做(我现在已经失败了很多次,一次尝试甚至用空白更新了行):
UPDATE Database2.Table1
SET (Database2.Table1.Column1, Database2.Table1.Column2, Database2.Table1.Column3)
VALUES
(Database1.Table1.Column1, Database1.Table1.Column2, Database1.Table1.Column3)
WHERE Database2.Table1.Column1 = Database1.Table1.Column1
这两个列已经包含相同的值,但其他两列不包含相同的值,这就是我希望通过此查询更改的内容。
每个表的外观如下:
数据库1.表1
[id]
[name]
[applicationdate]
[startdate]
[shortdescription]
[longdescription]
[displayimg]
[contact]
[website]
[created]
[urlbase]
[site]
[keywords]
[type]
[location]
数据库2.表1
[id]
[name]
[applicationdate]
[startdate]
[content]
[keywords]
[customerid]
[urlbase]
[shortdescription]
[meta]
[type]
[site]
[searchurlbase]
[lang]
[educationlength]
[locations]
[educationwebsite]
[contact]
[tags]
[educationtypes]
[created]
[category]
非常感谢任何帮助,感谢您的宝贵时间:)
抱歉,如果没有任何意义,当我试图解释我遇到的问题时,我很容易感到困惑
UPDATE dest
SET column2 = src.column2,
column3 = src.column3
FROM Database2.dbo.Table1 AS dest
INNER JOIN Database1.dbo.Table1 AS src
ON dest.column1 = src.column1;
鉴于您的整理问题,您可以在相等操作中指定整理。不知道哪一方提出了问题,并假设您不关心区分大小写:
UPDATE dest
SET column2 = src.column2,
column3 = src.column3
FROM Database2.dbo.Table1 AS dest
INNER JOIN Database1.dbo.Table1 AS src
ON dest.column1 COLLATE Finnish_Swedish_CI_AS
= src.column1 COLLATE Finnish_Swedish_CI_AS;
如果您关心区分大小写,请将这两个子句更改为_CS_AS_
one.
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)