Read XML FROM URL - SQL Server Forums

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 2005 Forums

Transact-SQL (2005)

Read XML FROM URL

Author

Topic

sdadabasha
Starting Member

1 Post

Posted - 2008-11-26 : 04:36:20

Hi,

I have a requirement to read xml file from a URL and store it in a table in database.

Is there any method to read data direclty from URL.
I know that we can use OPENXML but it is not reading from url.
Any help appreciated

Thanks in advance

Regards,
Shaik Dada Basha

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-26 : 04:39:54

Here is one example of how to read url content.
This specific example is how to read Google geocoding, but you can easily adapt the code to suit your needs.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=111356

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources