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('');

תÔØÓÚ:https://www.cnblogs.com/Jacob-Wu/p/9322268.html