Converting String Data to XML and XML to String Data

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.

Weiterlesen…