can i access web service in sql server using StoredProcedures.
can i call/pass values web service inside the stored procedure.
My requirement is,
i am doing some importan updation in sql server 2008. After updating the table i have to send one status (like "Success") to the web service.
i want to pass one value to a webservice.I can do it using some other way.But that will affects my productivity,so i decide to do in stored procedure itself.
cpughalnet
0 Points
1 Post
Sending/Passing value to webmethod using Stored Procedure
Nov 19, 2012 02:53 PM|LINK
Hi dude,
i have two questions
can i access web service in sql server using StoredProcedures.
can i call/pass values web service inside the stored procedure.
My requirement is,
i am doing some importan updation in sql server 2008. After updating the table i have to send one status (like "Success") to the web service.
i want to pass one value to a webservice.I can do it using some other way.But that will affects my productivity,so i decide to do in stored procedure itself.
Can you give code snippet do make it live.
Haixia Xie -...
Contributor
3031 Points
296 Posts
Microsoft
Re: Sending/Passing value to webmethod using Stored Procedure
Nov 21, 2012 04:59 AM|LINK
Hi cpughalnet,
Please refer a blog below which elaborates how to invoke a web service from a stored procedure.
http://www.codeproject.com/Articles/428200/How-to-invoke-a-Web-Service-from-a-Stored-Procedur
Best Regards.
Feedback to us
Develop and promote your apps in Windows Store