从SQL Server 2017开始，该
STRING_AGG功能可用，从而大大简化了逻辑：
select FieldA, string_agg(FieldB, '') as datafrom yourtablegroup by FieldA
在SQL Server中，您可以
FOR XML PATH用来获取结果：
select distinct t1.FieldA, STUFF((SELECT distinct '' + t2.FieldB from yourtable t2 where t1.FieldA = t2.FieldA FOR XML PATH(''), TYPE ).value('.', 'NVARCHAr(MAX)') ,1,0,'') datafrom yourtable t1;
