Home Forums SQL Server 2005 T-SQL (SS2K5) How to post xml string to url in storedproc? RE: How to post xml string to url in storedproc?

  • July 7, 2014 at 6:44 am

    #1727329

    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?

    https://www.google.com/search?q=SQL+CLR+to+call+a+web+service&oq=SQL+CLR+to+call+a+web+service

    Lowell

    --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!