sql将列转换为以逗号分隔的字符串

SELECT @CloneOfferIDs=STUFF(( SELECT ','+CONVERT(varchar(10),OfferID) FROM OfferPubInfo WHERE ParentOfferID=@OfferID FOR XML PATH('')),1,1,'')

 

 

我测试的SQL：

/*declare @s varchar(8000)select @s=stuff((SELECT ','+Code from t Where tt='dd' FOR XML Path('')),1,1,'')select @s*/