SQL server将查询到的多行结果，拼接成字符串(列转行)

select stuff((
select ','+UserName from tabname 
for xml path('')),1,1,'') as UserNamestr