Sql Server-查询一列的数据进行拼接

select convert(VARCHAR(10),memberid) +',' from t_member where teamid = 1009 for xml path('')