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 |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2003-10-06 : 01:25:48
|
| hi,I have the links of xml files in my database, I have to read these xml files get the data from them ,do some processing and then show the results .is there anyway to read the xml files which are online ,through the stored procedure.thanks in advance,regards,harshal.The Judgement of the Judge is as good as the Judge. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-10-06 : 05:39:16
|
| You need to write some external code for this. VB, VBS or C# are all suited to this. If you wrote it as a dll you could call it from a stored proc using sp_OACreate. But I think you would be better off calling it externally from a scheduled job.Damian |
 |
|
|
|
|
|
reading xml online