Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-12 : 07:47:27
|
| Hans writes "Hi there,I'm a newbie to XML and started looking into things. I hav a practical question: There is a table with xmldatafield in it. To use the data I need to transform it to a genuine relational table. What I do now is ask a developer to write a parser and create a new relational table. These requests are going to be more common. I was hoping to be able to automatically do this with SQL Server. Sofar no luck.I'm looking into XML in general and specifically in SQL Server.Everything I have found sofar are examples and descriptions of importing XML-files into a databasetable. What I see there is no such thing as an easy import: besides the data you need to have schemas, XSD, I don't know what.Is there a way for SQL Server to automatically import(parse?) aXMLdatastring into seperate tablefields? Or do I have to go in-deth into XML to be able to crack this?Tnx,Hans Brouwer" |
|
|
|
|
|
Importing XMLdata from a TABLE into another table