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 |
|
PeterG
Posting Yak Master
156 Posts |
 Posted - 2003-12-31 : 15:46:42
|
| in an xml file into a database.I receive the xml file containing a dataset (from a database table and saved as xml) and I need to save the contents of this xml file into another table with the same structure as the source database.Can I do this using T-SQL? Thanks. |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2004-01-01 : 14:30:24
|
| See if this link helps: http://www.sqlxml.org/faqs.aspx?faq=13I'd use the XML Bulk Load component that comes with SQLXML web release.--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
PeterG
Posting Yak Master
156 Posts |
Posted - 2004-01-02 : 17:14:37
|
| Is OpenXML available only in SQL Server 2000? If so, it's unfortunate because I am working with SQL Server 7.0. Is there another way of doing it in SQL Server 7.0? |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
|
|
|
|
|
How to save a dataset ...