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 |
|
js.reddy
Yak Posting Veteran
80 Posts |
 Posted - 2007-10-29 : 04:47:14
|
I want update existing table with xml file.for exampe I am having a table called booksbookid bookname price---------------------1 databases 5002 languages 4503 abcd 2004 soft skills 600 I want to update the above table with following xml file<books><book><bookid> 1 </bookid><bookname> databases by jsr </bookname><price> 350 </price></book><book><bookid> 2 </bookid><bookname> language by xxx </bookname><price> 450 </price></book></books> Thanks and Regards |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-29 : 04:54:19
|
| Consider using OPENXML .Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
|
|
|
update table with xml file