在sql server中，您可以使用FOR XML PATH
select SubscriberId,categoriesAdded=Stuff((SELECT ',' + CAST(CategoryId as VARCHAr(255)) FROM catsToAdd t1 WHERe t1.SubscriberId=@categoriesToAdd.SubscriberId FOR XML PATH ('')) , 1, 1, '' )from @categoriesToAdd as catsToAddGROUP BY SubscriberId
