What is the best approach to call web service from azure sql(from stored procedure)? I understand that azure sql doesn't support CLR assemblies(SQLCLR).
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
No, you cannot access external resources (network, file system, registry, etc) from Azure SQL Database. Neither SQLCLR nor OLE Automation stored procedures (i.e. sp_OA*) are available on that platform. Even during the year-and-a-half that Azure SQL Database supported SQLCLR (late 2014 through mid-April 2016), it was SAFE Assemblies only, and those can not do external operations.
Your only option is to handle this outside of Azure SQL Database, or use an Azure VM with SQL Server loaded on it (Express Edition is free, so you would only pay for the Azure VM itself, which might be a cost-effective option).
