Converting a Text Data Type to an XML Data Type

Many of us have stored XML in text columns for years to get around the size limits of the varchar data type. The XML data type was introduced in SQL 2005 to give us a better and richer alternative, but what's involved in converting our existing data to the XML data type? Join XML super user Kendal Van Dyke for a quick review of the issues involved.

Kendal Van Dyke is a Senior DBA with Channel Intelligence in Celebration, Florida. He uses XML extensively in the database at work and believes that the improvements to XML handling in SQL 2005 substantially change how and why we handle XML.

Gummi on 11/25/2008

rock

Satyabodhi Densmore on 1/2/2009

Presentation cutoff prematurely.

Jimmy May on 3/13/2009

Nice job--short, sweet, very helpful.

John Breidenbach on 3/13/2009

Good... Need more XML beginer videos

Mark on 3/13/2009

Did not open

Joe Pool on 6/19/2009

Would have been nice to see what XML in the table does and how it is usedd.

Mike Salo on 6/19/2009

Pretty simple, but it was well done.

Sara Karasik on 6/19/2009

too short. I'd like alot more about this new datatype, and how it can be used, and parsed

borjonx on 6/19/2009

the guy is a very good, clear speaker. not to fast or slow.

Prasanna Prabhu on 6/20/2009

If the table is big (too many rows) is there any easy way to get a list of all ROW(s), that fails ALTER COLUMN TO XML type. If YES, can you please let us know the command. This will help us identify the BAD rows, fix the data & then APPLY ALTER column... XML type...

punjwani on 6/22/2009

Need more detail as you mentioned in your video how to check XML before conversion.

Carla Wilson on 6/22/2009

A tip for how to go about finding the rows that have xml errors would be good.

Caleb Bell on 7/16/2009

Great video, thanks for explaining how to do it and some caveats!