赞
踩
通过函数STUFF转换
例子写法如下:
SELECT STUFF((SELECT ';'+SPDM FROM SHANGPIN where SPDM in ('545454','BZSP01','HSP02','HSP05') for xml path('')),1,1,'')