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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-07-13 : 04:55:02
|
| Hello friends...We have sql server 2000 and i need to read one perticular xml and from that i want ID field stored in one table...is it possible by query analyzer to read xml and stored ID in table...I have only path of that xml file... like select ID from ("D:\XMLFolder\*.xml) that i want |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-13 : 05:31:03
|
| If it's a simple format then you can use thishttp://www.nigelrivett.net/SQLTsql/ParseXML.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2006-07-13 : 08:00:06
|
| Or maybe...http://www.perfectxml.com/articles/xml/importxmlsql.asp#openxmlRyan Randallwww.monsoonmalabar.com London-based IT consultancy Solutions are easy. Understanding the problem, now, that's the hard part. |
|
|
|
|
|
|
Reading ID from XML file???