将同一个记录的所有附件获取后服务器保存附件的真实名称用‘|’隔开,可用于表格中的缩略图展现
select mainID,
isnull(STUFF((SELECT '|'+Convert(varchar(100),SaveName) FROM vw_File_fujian_basic WHERE mainID=A.mainID FOR XML PATH('')),1,1,''),'') AS FuJianImg
from vw_File_fujian_basic A where Type=4 group by mainID