怎样把一个数据库里的字段内容替换到另一个数据库中？

从两个区分别打开数据库

sele 1

use XX

sele 2

use XXX

将另一个库中的关键字建立索引，

inde on AA to aaa

按相同关键字将两个表建立关联

set relation to AA into b

用replace命令替换

repl BB with b.BB1

这里假设另一个表在B区打开，且两个表用相同的关键字AA关联，用B区的BB1替换A区的BB

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)

执行命令：Update table2 Set tm=dm From table1 Where table2.name=table1.name

这样就可以了

如果 *** 作成功了，请支持一下！

---