sqlserver 查询结果用逗号拼接

SELECT STUFF(
(SELECT ',' + id FROM assets where id in('4028e481467e27a4014683c552db1794','4028e481467e27a4014683c6ff7717d4') FOR XML PATH('')),
1, 1, '') AS id;