SELECT Pro_ID,STUFF((SELECT ','+KW_Name FROM Table WHERE Pro_ID = A.Pro_ID FOR XML PATH('')),1,1,'') AS [KW_Name] FROM Table A GROUP BY Pro_ID
本文共 195 字,大约阅读时间需要 1 分钟。
SELECT Pro_ID,STUFF((SELECT ','+KW_Name FROM Table WHERE Pro_ID = A.Pro_ID FOR XML PATH('')),1,1,'') AS [KW_Name] FROM Table A GROUP BY Pro_ID
转载于:https://www.cnblogs.com/netblaze/p/11102619.html