一列多行合并，逗号分隔

select c.ContainerName from Container c

 

SELECT STUFF((SELECT ';' + c.ContainerName FROM container c FOR XML PATH('')) ,1,1,'') ContainerNames