1 sql server 利用多重赋值将一列的数据以逗号分隔，返回

declare @mav varchar(max)

select @mav=coalesce(@mav+', '+d.Name,d.Name)

   from ( select Name

     from HumanResources.Department) d

order by d.Name

select @mav