sql笔记

一、sqlserver两个数据库的两个表关联修改

update a set a.username = b.username, a.password = b.password
from db1.dbo.user a, db2.dbo.user b 
where a.id = b.id