SqlServer将多行数据某字段以逗号分隔变成一行数据
select NI.Id,
Code = STUFF((SELECT ',' + BidTypeName
FROM NoticeBidType NBT
WHERE NBT.NoticeId = NI.Id
FOR XML PATH ('')), 1, 1, '')
from NoticeInfo NI