更新表中多条数据

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