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
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