xml - SQL Server XQuery: How to avoid "illegal qualified name character" exception? -
i'm working on xquery may/can contain characters ">", "<" , single quotes.
how avoid breaking xml parser?
my xml form this
<root> <container> <item>(d.field <> 0)</item> </container> </root>
the "xml" you've shown isn't xml.
either of following xml:
<root> <container> <item>(d.field <> 0)</item> </container> </root>
or:
<root> <container> <item><![cdata[(d.field <> 0)]]></item> </container> </root>
Comments
Post a Comment