SQL:UPDATE test1 SET name = (SELECT y.name FROM DB2.dbo.test2 y WHERE test1.id = y.id)
用Update Select批量更新某一字段的值[可以跨库]
最新推荐文章于 2019-12-17 17:09:28 发布
SQL:UPDATE test1 SET name = (SELECT y.name FROM DB2.dbo.test2 y WHERE test1.id = y.id)