Converting String Data to XML and XML to String Data
Posted by: Simple Talk,
on 01 Feb 2012 |
View original | Bookmarked: 0 time(s)
We all appreciate that, in general, XML documents or fragments are held in strings as text markup. In SQL Server, XML variables and columns are instead tokenised to allow rapid access to the data within. This is fine, but can cause some odd problems, auch as 'entitization'. What, also, do you do if you need to preserve the formatting? As usual Rob Sheldon comes to our aid....