create table tb(name varchar(30))
 
insert into tb
select ‘张三‘ union all
select ‘李四‘
 
 
select distinct STUFF(
                       (select ‘,‘+name
                        from tb for xml path(‘‘)
                       ),1,1,‘‘
                     ) as name
from tb