XML over HTTP in SQL

[qsac]

i basically want to store the contents of a XML file to tsql variable.

so

declare @strXML varchar(8000)
set @strXML =

http://test.com/xml

The above is what i want to do. I know the above syntax is incorrect, but does anyone know how/if this can be accomplished in TSQL?

Thank You,
Q

 

[philhege]

Native T-SQL (AFAIK in 2K) can't do this. You have to write VB to use the XMLHTTP object and retrieve the contents of the site. Create a DLL or EXE and call it with xp_cmdshell.



Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
A priest, a lawyer, and a rabbi walk into a bar. The bartender looks up and says "What is this, a joke?