多行字符串拼接

 

SELECT STUFF((SELECT ','+PlatformName FROM NA_AbilityPlatformBaseInfo FOR XML PATH('')),1,1,'')

SELECT STUFF((SELECT ','+PlatformName FROM NA_AbilityPlatformBaseInfo FOR XML RAW(''),ELEMENTS),1,1,'')

View Code

 

转载于:https://www.cnblogs.com/ch-863481664/p/5842307.html