Post reply

getting xml data

  • December 17, 2010 at 7:40 am

    #242531

    Is there a way to get xml data from a url in stored procedure.

    E.g. I have http://xyz.aspx. It contains only xml data.

    Is there a way to get this xml data in stored procedure?

  • December 20, 2010 at 9:48 am

    #1264681

    The only way I see is to write a CLR stored procedure that will go to the url to fetch the XML. But the assembly will have to be configured as EXTERNAL_ACCESS or UNSAFE, what may raise objections from DBAs.

    In my opinion, it would be better if you had business layer functionality that would take the xml and pass it to your stored procedure.

    Regards

    Piotr

    ...and your only reply is slàinte mhath

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply