title: How to invoke webservice from SQL Server stored procedure
body: <p>I would like to know how to use a web service from a SQL Server stored procedure. I have a table in which the columns specify the city and state of the user. I want to pass this address as a parameter to Google Geocoding API web service and get the latitude and longitude. </p>
  
  <p>I have successfully made use of this geocoding api in c#. But now, I want to use it in a stored procedure. </p>
  
  <p>Can any one please suggest how to get this done? Or please provide me any links?</p>
  
  <p>Any help will be appreciated!! </p>
  
  <p>Thanks.</p>