Thanks! We'll email you
when relevant content is
added and updated.
Using SQL SERVER 2008 R2:
I have a table with 35 million records, one of the field is of datatype VARCHAR(MAX), it has well formed XML stored. Now we have to convert this column to XML data type. Trying 2 possible ways
1) Creating new column with XML data type and updating that column using CAST(XMLFeildname as XML)-- taking a week to do so.
2) Just altering table to change datatype to XML, this is also taking more 1 day.
Please suggest an efficient way to do this faster.
Thanks in advance.
SQL SERVER 2008 R2
December 3, 2013 10:19 PM
December 3, 2013 10:26 PM