September 3, 2008 at 12:05 pm
I want to create a table with an xml datatype column, bulkload it and eventually read the xml column out as a rowset. BOL is pretty start forward about the first two steps but the examples of reading the data are confusing me. All the examples for sp_xml_preparedocument use a set piece of xml for the xmltext parameter.
How do you call sp_xml_preparedocument when you want to get rowset data from an xml column in a table?
Thanks
David
September 3, 2008 at 12:25 pm
You do not really need sp_xml_preparedocument except for OPENXML, which you do not really need either in SQL 2005.
What you should look at are the XML datatypes and the XML datatype methods (.query, .nodes, .exists, .value)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply