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

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

posted @ 2016-04-01 11:46 dekevin 阅读(2228) 评论(0) 收藏举报