Webservice From SQL

Question

Can I call a remote webservice from a Stored Procedure and use the values that areretuned?

Answer 1

If you're using SQL 2005/2008, you could do this from a CLR stored procedure if you have the ability to install and run these. For more info:

http://msdn.microsoft.com/en-us/library/ms190790.aspx