High level description XML to relational

[RRinTetons]

I've got XML text stored in nvarchar columns. (it's not my database!) I need to query a single piece of data out of the XML. I'm guessing I have to do something to convert the text to 'real' XML, then do something to extract a schema, then query it to get my data using XQuery.

That's a wild ass guess based on just enough information to make me dangerous.

Can somebody give me a bit of a roadmap on the best way to go about this? I'll be glad to figure it out, but it would be nice to not head off in the wrong direction TOO many times.

-
Richard Ray
Jackson Hole Mountain Resort

 

[markros]

Check

http://beyondrelational.com/xml/default.aspx

- one of the labs should work for the particular problem you'll have.

PluralSight Learning Library