UPDATE a SET NameSpell =b.NameSpell FROM dbo.MDS_Doctor a,
(
SELECT DoctorName, dbo.fn_GetPinyin(DoctorName) AS NameSpell FROM dbo.MDS_Doctor
)
WHERE a.DoctorName = b.DoctorName
转载于:https://www.cnblogs.com/hanshasha/archive/2012/05/15/2502055.html
UPDATE a SET NameSpell =b.NameSpell FROM dbo.MDS_Doctor a,
(
SELECT DoctorName, dbo.fn_GetPinyin(DoctorName) AS NameSpell FROM dbo.MDS_Doctor
)
WHERE a.DoctorName = b.DoctorName
转载于:https://www.cnblogs.com/hanshasha/archive/2012/05/15/2502055.html