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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 xml and sql server 2k

Author  Topic 

mikejohnson
Posting Yak Master

153 Posts

Posted - 2002-11-12 : 15:42:54
I am building an application that will download multiple xml files. I need to take the xml files, read them, and according to different field values in the xml docs, insert/delete/edit records in my sql server 2k database. Can anyone point me in the right direction of starting to do the research on the best way to do this. I've heard a lot about the neat tools and functionality that sql server 2k has to work with xml but do not know how to use them. Any help is appreciatiated!
thanx,
mike

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-11-12 : 16:33:48
If you haven't already, download SQLXML 3 SP1

[url]http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/msdn-files/027/001/824/msdncompositedoc.xml[/url]

It has some pretty good documentation. Also this site is excellent [url]http://www.sqlxml.org[/url]



HTH
Jasper Smith
Go to Top of Page
   

- Advertisement -