title: Accessing Azure Storage from stored procedure
body: <p>We have recently migrated our data from on-premises SQL Server ( SQL Server 2012 ) to Azure Database.  Refer to one such table that we had in on-premises database named, 'Customer'</p>
  
  <pre><code>Customer
  -------------------------------------------------------------
  id   | name     |   GUID         |        ProfilePhoto
  -------------------------------------------------------------
  1       Name1     xxxx-yyyy-zzz           &lt;&lt;BLOB DATA&gt;&gt;
  -------------------------------------------------------------
  2       Name2     xxxx-yyyy-zzB           &lt;&lt;BLOB DATA&gt;&gt;
  -------------------------------------------------------------
  3       Name3     xxxx-yyyy-zzA           &lt;&lt;BLOB DATA&gt;&gt;
  </code></pre>
  
  <p>Also we have a stored procedure in database called GetProfilePhoto_sp(guid)
  which accepts GUID and returns corresponding ProfilePhoto which belongs to 'Customer' table.</p>
  
  <p>After migrating '<code>Customer</code>' table and <code>GetProfilePhoto_sp(guid)</code> on to Azure SQL server we don't have 'ProfilePhoto' column as we have made decision to store unstructured data (i.e. ProfilePhoto ) onto Azure Blob Storage.</p>
  
  <p>Now our GetProfilePhoto_sp is point towards an invalid column as we don't have 'ProfilePhoto' column anymore.
  Do we have any provision to access Azure Storage from GetProfilePhoto_sp  Stored Procedure?</p>