MSSQL for XML

select ',' + ta.value
from ta for xml path;
 
select ','+ value
from ta for xml path('');
 
select *
from ta for xml path('row');
 
select *
from ta for xml path('');