多行字符串拼接

 

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

 

posted @ 2016-09-05 15:03  ch_81664  阅读(215)  评论(0)  编辑  收藏  举报