SELECT REPLACE( REPLACE((SELECT Name FROM common.Common_Setup_CompanyData T WHERE CompanyID<39 FOR XML AUTO),'<T Name="',','),'"/>',',')
DECLARE @dd NVARCHAR(1000)
SET @dd=( SELECT REPLACE((SELECT Name FROM common.Common_Setup_CompanyData T WHERE CompanyID<39 FOR XML AUTO),'<T Name="',',') )
SET @dd= REPLACE(@dd,'"/>','')
SELECT Stuff(@dd,1,1,'')
![](https://img2024.cnblogs.com/blog/35695/202407/35695-20240713070336838-1837943664.jpg)