问题描述:SQL Server 在添加 for xml path后, 返回字段信息为net.sourceforge.jtds.jdbc.ClobImpl@2a7b12e
SELECT
(STUFF(
(SELEC ',' + kep_name FROM USER FOR xml path ('')),
1,1,'')
) AS 'name'
解决方案1 :格式类型转换
示例如下:
SELECT
CONVERT (varchar (800),
(STUFF(
(SELEC ',' + kep_name FROM USER FOR xml path ('')),
1,1,'')
)
) AS 'name'