如何消除“FOR XML PATH”中的XML转义字符？ [英] How to eliminate XML Escape Characters in "FOR XML PATH"?

问题描述

嗨朋友们，



我需要消除 XML转义字符（，''''<<>>& &）

使用FOR XML PATH后，不使用REPLACE命令我需要解决此问题。

请参考我的示例数据，然后给出解决方案。

Hi Friends,

I need to eliminate XML Escape Characters (" ",'' ''< <> >& &)
after using "FOR XML PATH", With out using "REPLACE" Command I need to solve this.
Refer my sample data and pls give the solution.

-- Tables Creation
IF OBJECT_ID('TempDB..#Test') IS NOT NULL DROP TABLE #Test
CREATE TABLE #Test (ID INT, Name VARCHAR(30))
-- Sample Data
INSERT INTO #Test(ID, Name) VALUES(1,'Test'),(2,'&Test'), (3,'<test>')
-- Actual Data
SELECT ID, Name FROM #Test
-- Reguired Output
'Test,&Test,<test>'
SELECT STUFF((SELECT ','+Name AS [text()] FROM #Test FOR XML PATH('')),1,1,'')
-- Current Output
'Test,&Test,<test>'

问候，

GVPrabu

Regards,
GVPrabu

推荐答案

大家好，



最后我找到了解决方案....

Hi All,

At last I find the solution for this....

SELECT STUFF((SELECT ','+Name AS [text()] FROM #Test FOR XML PATH(''), TYPE).value('.', 'VARCHAR(MAX)'),1,1,'') AS 'NameList'

检查:-)



问候，

GVPrabu

Check this :-)

Regards,
GVPrabu

Select STUFF((SELECT ',' + cast(id as varchar) FROM x with (nolock)
 FOR XML PATH('')),1,1, '') as c

这篇关于如何消除“FOR XML PATH”中的XML转义字符？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！