sqlserver 中一对多的查询结果拼接的查询函数STUFF
[问题上报文件路径]=STUFF((select \’,\’+SavePath+PhyFileName from Sys_Accessories where OperationCode=\’Question_Report\’ and OperationID=R.QRID order by CreateTime for xml path(\’\’)),1,1,\’\’)
[问题上报文件路径]=STUFF((select \’,\’+SavePath+PhyFileName from Sys_Accessories where OperationCode=\’Question_Report\’ and OperationID=R.QRID order by CreateTime for xml path(\’\’)),1,1,\’\’)