原始数据:
select UserName from com_t_userinfo where username like '测试%'
查询结果:
需求所要结果:
select UserName+',' from com_t_userinfo where username like '测试%' for xml path ('')
查询结果:
原始数据:
select UserName from com_t_userinfo where username like '测试%'
查询结果:
需求所要结果:
select UserName+',' from com_t_userinfo where username like '测试%' for xml path ('')
查询结果: