FOR XML AUTO将数据库表的一个字段的数据查询拼接为带间隔符的字符串

SELECT REPLACE( REPLACE((SELECT Name FROM common.Common_Setup_CompanyData T WHERE CompanyID<39 FOR XML AUTO),'<T Name="',','),'"/>',',')SELECT REPLACE( REPLACE((SELECT Name FROM commo