一个产品收藏表 Collection , 把该产品被收藏的人拼接在一列中如下:
SQL SERVER
SELECT ProjectID, UserIDs = ','+(STUFF((SELECT ',' + CONVERT(VARCHAR,UserID)FROM Collection WHERE ProjectID =
a.ProjectID FOR XML PATH('')),1,1,'')) FROM Collection a GROUP BY ProjectID ;
一个产品收藏表 Collection , 把该产品被收藏的人拼接在一列中如下:
SQL SERVER
SELECT ProjectID, UserIDs = ','+(STUFF((SELECT ',' + CONVERT(VARCHAR,UserID)FROM Collection WHERE ProjectID =
a.ProjectID FOR XML PATH('')),1,1,'')) FROM Collection a GROUP BY ProjectID ;
转载于:https://www.cnblogs.com/wms01/p/7161203.html