When I run this query: SELECT xmlelement(name my_xslt_tag, (SELECT XMLPARSE (CONTENT '<![CDATA[<foo>bar</foo><bar>foo</bar>]]>')) )
I get this result:
"<my_x005F_xslt_tag><![CDATA[<foo>bar</foo><bar>foo</bar>]]></my_x005F_xslt_tag>"
Running soemthing similar in mssql prevents the x005F
SELECT 'data' AS p,'data' AS k
FOR XML RAW('xmlst')
How do I prevent the x005F in the tagname without changing the tagname?
Best,
Peter Kroon
