Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to post xml string to url in storedproc? Expand / Collapse
Posted Monday, July 7, 2014 4:38 AM


Group: General Forum Members
Last Login: Wednesday, October 15, 2014 1:11 AM
Points: 12, Visits: 60

I want to post a XML string to an url

ex :
where nxml is an xml string

so when user hits the url he can view the xml content on the browser.

How can I do this using storedproc.?

Thanks in advance.
Post #1589799
Posted Monday, July 7, 2014 6:44 AM



Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 13,883, Visits: 35,807
SQL server is probably not the target platform you want to use for this; is this supposed to send / retrieve information from the web service and return it to a user, or just blindly send to your web service?

anyway, to do it via SQL server,you will have to create and use a CLR(Common Language Runtime) procedure which is specifically designed to call your web service with the appropriate parameters, and consume any answers back.

there's lots of examples out there, does this help?


help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1589828
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse