www.9778.com:sql update left join 更新,字段内容分隔符提取

UPDATE a  SET       [Province] = parsename(replace([FullName],'-','.'),2) from [dbo].[T_B_Emp] a left join [MLYY_MIS].[dbo].[T_B_Area] b on b.ID = a.AreaID

www.9778.com:sql update left join 更新,字段内容分隔符提取。 

www.9778.com,其中  parsename分隔符提取字段内容

如 XXX-XXX-XXXX