实现类似mysql group_concat的功能

SELECT SG.Id       ,SG.GroupName        ,HostNames = STUFF((SELECT ',' + SH.[HostName]          FROM SaltHost SH          WHERE SG.Id = SH.HostGroupId          FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')FROM [SaltGroup] SGORDER BY SG.Id