【SQL】更新到另一个库的表。

将sq_data1的UserInfo表复制到 test_data1的UserInfo里

 

Update sq_data1.dbo.UserInfo set

ID=ct.ID, ParentId=ct.ParentId, UserName=ct.UserName, 
Telephone=ct.Telephone, Password=ct.Password, Email=ct.Email, Hits=ct.Hits, 
JobTitle=ct.JobTitle, CompanyName=ct.CompanyName, Address=ct.Address, 
AddDate=ct.AddDate, CusId=ct.CusId

From sq_data1.dbo.cb_card c left join test_data1.dbo.UserInfo ct
on c.ID = ct.ID
where c.ID= 123456