mysql与mssql中将多行转为一行

• 一、mysql 编写，关键词 group_concat

select  GROUP_CONCAT(a.role_name) rolename from t_role as a 

• 二、mssql 编写，关键词 for xml path(’’)

SELECT
   STUFF((SELECT distinct ',' + pt.pestsName 
			FROM F_PreventPestRecord as prv 
			left join CloudFarmXCCSdb0.dbo.Fp_pests as pt on pt.pestsId = prv.pestId 
			and prv.PreventRecordId = prev.PreventId  FOR XML PATH('')),1,1,'') as pestsName
FROM dbo.F_Prevent as prev
where prev.showState = 0 and prev.grouporuserId = 261 and  prev.PreTime < '2020-01-01'

• 三、补充知识 STUFF
  参考学习 stuff