记下备查
update d
set d.ChinesePhoneticFirstName = s.ChinesePhoneticFirstName,
d.EnglishPhoneticName = s.EnglishPhoneticName
from db_dest.dbo.Employees as d inner join db_src.dbo.Employees_hwz as s
on s.TransactorID = d.TransactorID
where ....
阅读(5661) | 评论(0) | 转发(0) |