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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2006-08-13 : 08:13:14
|
| how can i import an xml to sql server 2000where i have lots of child and sub childs,so when importing the xml the table will be build in runtime ?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-08-14 : 10:10:03
|
| Well, you'll need to build the XML strucutre before inserting it, or use XPath to insert the nodes into the XML column after the initial insert.What do the XML and data structures look like?What do you mean by the table being 'build at runtime' - does teh application build a table each time it is invoked?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
importing xml into sql server