select
Fguid, name=stuff((select ','+FSMC from (SELECT ZFFS.FSMC,DDZFMX.Fguid FROM ZFFS,DDZFMX WHERE ZFFS.[GUID]=DDZFMX.ZFFS_GUID)as a
where Fguid=t.Fguid for xml path('')),1,1,'')
from DDZFMX t group by Fguid
Stuff(expression1_Str,startIndex,lengthInt,expression2_Str)
函数共有四个参数,其功能是将expression1_Str中自startIndex位置起删除lengthInt个字符,然后将expression2插入到expression1_Str中的startIndex位置。