sql server列转行拼接

-- 列转行拼接
select stuff((select ','+字段名 from 表名 for xml path('')),1,1,'')
-- 示例
select stuff((select ','+user_name from t_user for xml path('')),1,1,'')