How can I retain CDATA tags when storing query results in an Xml variable?

by

You can’t. The XML data type does not preserve CDATA sections.

Have a look here for a discussion about the subject.

http://social.msdn.microsoft.com/forums/en-US/sqlxml/thread/e22efff3-192e-468e-b173-ced52ada857f/

More Related Contents:

  1. What does in XML mean?
  2. Is there a way to escape a CDATA end token in xml?
  3. Html inside XML. Should I use CDATA or encode the HTML [closed]
  4. Add CDATA to an xml file
  5. How to query xml column in tsql
  6. Using CDATA inside another CDATA
  7. Does any xml-based standard exist to define HTTP requests and responses as xml files?
  8. How to fix error: The markup in the document following the root element must be well-formed
  9. Does a valid XML file require an XML declaration?
  10. Any tools to generate an XSD schema from an XML instance document? [closed]
  11. XPath select all elements between two specific elements
  12. javax.xml.bind.JAXBException Implementation of JAXB-API has not been found on module path or classpath
  13. Extraction of data from a simple XML file
  14. How to use XPath contains() here?
  15. Is writing self closing tags for elements not traditionally empty bad practice?
  16. How to properly assemble a valid xlsx file from its internal sub-components?
  17. How to restrict the value of an XML element using xsi:type in XSD?
  18. XML Schema (XSD) validation tool? [closed]
  19. processContents strict vs lax vs skip for xsd:any
  20. How to declare XPath namespaces in xmlstarlet?
  21. R: convert XML data to data frame
  22. What is the XPath to select a range of nodes?
  23. Incrementing and checking the counter variable in XSLT
  24. Date operations on xsl 1.0
  25. How to parse xml in Angular 2
  26. How to remove namespaces from XML using XSLT
  27. How to link up XML file with XSLT file?
  28. VBA pull XML data to Excel
  29. Format XML code in Eclipse
  30. How to add a newline (line break) in an XML file?

Leave a Comment