SQL跨数据库更新

两个数据库yimingong,australia,两个表company,companytest,要跨数据库更新，把yimingong数据库内company表内的Com_i... 两个数据库yimingong, australia,两个表company,companytest,要跨数据库更新，把yimingong数据库内company表内的Com_introduce更新成australia库内companytest表里的company_intro字段的数据，后面还有一大串条件。下面的语句不知道那里错了

UPDATE yimingong.dbo.company
SET yimingong.dbo.company.Com_introduce = australia.dbo.companytest.company_intro
FROM australia.dbo.companytest as a, yimingong.dbo.company as b WHERE (a.id = 2 AND b.Com_Id = 1)

OR
(a.id = 14 AND b.Com_Id = 2) OR
(a.id = 18 AND b.Com_Id = 3) OR
(a.id = 5 AND b.Com_Id = 4) OR
(a.id = 16 AND b.Com_Id = 5) OR
(a.id = 18 AND b.Com_Id = 6) OR
(a.id = 15 AND b.Com_Id = 7) OR
(a.id = 4 AND b.Com_Id = 8) OR
(a.id = 3 AND b.Com_Id = 9) OR
(a.id = 12 AND b.Com_Id = 10) OR
(a.id = 6 AND b.Com_Id = 11) OR
(a.id = 8 AND b.Com_Id = 12) OR
(a.id = 11 AND b.Com_Id = 13) OR
(a.id = 10 AND b.Com_Id = 14) OR
(a.id = 9 AND b.Com_Id = 15) OR
(a.id = 7 AND b.Com_Id = 16) OR
(a.id = 19 AND b.Com_Id = 17) OR
(a.id = 20 AND b.Com_Id = 19) OR
(a.id = 21 AND b.Com_Id = 20) OR
(a.id = 22 AND b.Com_Id = 21) 展开

 我来答

3个回答

#热议# 为什么有人显老，有人显年轻？

roy_88
2010-02-05 · TA获得超过3696个赞

知道大有可为答主

回答量：2914

采纳率：100%

帮助的人：2793万

我也去答题访问个人页

关注

展开全部

UPDATE b
SET b.Com_introduce = a.company_intro --这里改改
FROM australia.dbo.companytest as a, yimingong.dbo.company as b 
WHERE 
 (a.id = 2 AND b.Com_Id = 1) OR
 (a.id = 14 AND b.Com_Id = 2) OR
 (a.id = 18 AND b.Com_Id = 3) OR
 (a.id = 5 AND b.Com_Id = 4) OR
 (a.id = 16 AND b.Com_Id = 5) OR
 (a.id = 18 AND b.Com_Id = 6) OR
 (a.id = 15 AND b.Com_Id = 7) OR
 (a.id = 4 AND b.Com_Id = 8) OR
 (a.id = 3 AND b.Com_Id = 9) OR
 (a.id = 12 AND b.Com_Id = 10) OR
 (a.id = 6 AND b.Com_Id = 11) OR
 (a.id = 8 AND b.Com_Id = 12) OR
 (a.id = 11 AND b.Com_Id = 13) OR
 (a.id = 10 AND b.Com_Id = 14) OR
 (a.id = 9 AND b.Com_Id = 15) OR
 (a.id = 7 AND b.Com_Id = 16) OR
 (a.id = 19 AND b.Com_Id = 17) OR
 (a.id = 20 AND b.Com_Id = 19) OR
 (a.id = 21 AND b.Com_Id = 20) OR
 (a.id = 22 AND b.Com_Id = 21)


本回答被提问者采纳






已赞过已踩过<

你对这个回答的评价是？
评论收起

华天软件
2025-03-05 广告

华天软件PDM近30年实施经验,服务客户数千家,功能完善,提高设计复用率,降低研发成本40%,实现跨部门信息共享+无纸化研发+缩短产品研发周期+降低成本，为企业构建数字化智能制造全面应用，打好坚实基础，加速企业数字化转型，更多资料详情咨询4... 点击进入详情页

本回答由华天软件提供

alicus
2010-02-05 · TA获得超过198个赞

知道答主

回答量：173

采纳率：0%

帮助的人：141万

我也去答题访问个人页

关注

展开全部

update 好像后面不能跟from语句吧?你把from 语句去掉，把where后面的a换成australia.dbo.companytest，把b换成yimingong.dbo.company 试试？

已赞过 已踩过<

评论收起

匿名用户
推荐于2017-08-05

展开全部

UPDATE b
SET b.Com_introduce = a.company_intro --这里改改
FROM australia.dbo.companytest as a, yimingong.dbo.company as b
WHERE
(a.id = 2 AND b.Com_Id = 1) OR
(a.id = 14 AND b.Com_Id = 2) OR
(a.id = 18 AND b.Com_Id = 3) OR
(a.id = 5 AND b.Com_Id = 4) OR
(a.id = 16 AND b.Com_Id = 5) OR
(a.id = 18 AND b.Com_Id = 6) OR
(a.id = 15 AND b.Com_Id = 7) OR
(a.id = 4 AND b.Com_Id = 8) OR
(a.id = 3 AND b.Com_Id = 9) OR
(a.id = 12 AND b.Com_Id = 10) OR
(a.id = 6 AND b.Com_Id = 11) OR
(a.id = 8 AND b.Com_Id = 12) OR
(a.id = 11 AND b.Com_Id = 13) OR
(a.id = 10 AND b.Com_Id = 14) OR
(a.id = 9 AND b.Com_Id = 15) OR
(a.id = 7 AND b.Com_Id = 16) OR
(a.id = 19 AND b.Com_Id = 17) OR
(a.id = 20 AND b.Com_Id = 19) OR
(a.id = 21 AND b.Com_Id = 20) OR
(a.id = 22 AND b.Com_Id = 21)