update b set b.x=a.x from 数据库a.dbo.A as a join 数据库B.dbo.b as b where a.关键字=b.关键字(连接条件)
UPDATE A SET A.x = B.x FROM 数据库A.dbo.表A AS A INNER JOIN 数据库A.dbo.表B AS B ON A.id = B.id
34,588
社区成员
254,588
社区内容
加载中
试试用AI创作助手写篇文章吧