title: how to call web api inside of azure sql cloud? is it supported?
body: <p>my question is simple but i can not find an answer . calling restful service in sql stored procedure . i decided to deploy my azure environment. but my team lead said "it is not supported" could you show me how to implement in hosted azure sql? can i call it from AZURE environment in azure SP?</p>
  
  <h2>Query</h2>
  
  <pre><code>select Name
        ,xml_data.value('(/data/info/@x)[1]', 'int') as [Info.x]
        ,xml_data.value('(/data/info/@y)[1]', 'int') as [Info.y]
        ,xml_data.value('(/data/info/.)[1]', 'varchar(10)') as [Info]
  from   #temp
  </code></pre>
  
  <h2>Result</h2>
  
  <pre><code>Name     Info.x    Info.y    Info
  -------  --------  --------  ---------
  one         42        99     Red
  two         27        72     Blue
  three       16        51     Green
  four        12        37     Yellow
  </code></pre>
  
  <p>.
  ------ Edit [2014-01-29] ------</p>