0
Generating XML CData Element from SELECT Statement
MS SQL Server has data type of XML since SQL Server 2005. The XML data type is a subset of NVARCHAR or VARCHAR, so string data can be easily converted to XML value by running the following query/funct