Altova Mailing List Archives>Archive Index >microsoft.public.xml Archive Home >Recent entries >Thread Prev - XML datatype to columned dataset >Thread Next - Re: XML datatype to columned dataset Re: XML datatype to columned datasetTo: NULL Date: 7/18/2007 6:13:00 PM Daniel Bass wrote: > Give a column of XML datatype containing this: > > <Foo> > <Name>Bob</Name> > <Area>Ghana</Area> > <Interest>Polar Hiking</Interest> > </Foo> > > > How do I write SQL that will produce a data set (DYNAMICALLY)? > > Name Area Interest > ----------------------------- > Bob Ghana Polar Hiking > > > The idea is that the name of the elements in my XML are untyped, and may > change. But I'd like a dynamic query to handle this mapping. The DataSet has a ReadXml method, if you simply read in that above XML using that method then the DataSet instance has one table named Foo with three columns Name, Area, and Interest. -- Martin Honnen --- MVP XML http://JavaScript.FAQTs.com/ | ||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
