select sname from studenttb
结果:
张三
李四
王五
如何变成:张三，李四，王五
------解决方案--------------------
- SQL code
DECLARE @STR VARCHAR(8000)SELECT @STR=ISNULL(@STR+',','')+name FROM ASELECT @STR
------解决方案--------------------
- SQL code
select (select ltrim(NAME)+',' from tb for xml path('')) as a