XML update (ntext column)

tusharkale · July 24th, 2008, 01:24 PM

Can I convert entire my ntext column to XML type. But all xmls are stored in ntext with encoding UTF-8.

This will remove the need of conversion to xml for every id.

I will create new table with two column ID (int) and xml_doc( XML ). Copy my ntext column to xml_doc. before I need to do somethign with wncoding thing... which i dont know how to do it for an entire column..

then processing will be faster..once all processing done i will convert entire my column back into ntext and with encoding utf-8.

Is it possible????

joefawcett · July 24th, 2008, 01:25 PM

Code:

INSERT tblNewTable (xmlData) SELECT CAST(ntextData AS xml) FROM tblOldTable;

Just need to set up tblNewTable with an XML data type column etc.

--

Joe (Microsoft MVP - XML)