SQL Server

Upload a Blob using a Container’s Shared Access Signature

See more Azure Cloud Storage Examples

Shows how to upload an Azure blob using a URL with a shared access signature. SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    -- To upload a file we're simply sending a PUT with the content of the data.  For example:

    -- PUT https://myaccount.blob.core.windows.net/pictures/photo.jpg?sv=2015-02-21&st=2015-07-01T08%3a49Z&se=2015-07-02T08%3a49Z&  sr=c&sp=w&si=YWJjZGVmZw%3d%3d&sig=Rcp6gQRfV7WDlURdVTqCa%2bqEArnfJxDgE%2bKH3TCChIs%3d HTTP/1.1  
    -- Host: myaccount.blob.core.windows.net  
    --   
    -- Content-Length: 12  
    --   
    -- Hello World.  

    -- Upload a string to a helloWorld.txt file in the "mycontainer" container, in the "chilkat" account.
    DECLARE @url nvarchar(4000)
    SELECT @url = 'https://chilkat.blob.core.windows.net/mycontainer/helloWorld.txt?sv=2021-06-08&ss=bfqt&srt=sco&sp=rwdlacupiyx&se=2023-02-12T21:30:53Z&st=2023-02-12T13:30:53Z&spr=https&sig=HB8CoZiD7EJD1rQNIVnLl%2Bq7kyLcOCnSXR14TadBv6s%3D'

    DECLARE @http int
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'x-ms-blob-type', 'BlockBlob'

    DECLARE @resp int
    EXEC @hr = sp_OACreate 'Chilkat.HttpResponse', @resp OUT

    EXEC sp_OAMethod @http, 'HttpStr', @success OUT, 'PUT', @url, 'Hello World.', 'utf-8', 'text/plain', @resp
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @resp
        RETURN
      END

    DECLARE @statusCode int
    EXEC sp_OAGetProperty @resp, 'StatusCode', @statusCode OUT

    PRINT 'response status code: ' + @statusCode

    EXEC sp_OAGetProperty @resp, 'StatusText', @sTmp0 OUT
    PRINT 'response status text: ' + @sTmp0

    IF @statusCode = 201
      BEGIN

        PRINT 'Success.'
      END
    ELSE
      BEGIN

        PRINT 'Failed.'
      END

    -- -------------------------------------------------------------------------------------------------
    -- Upload from a file...

    -- Upload a binar file to a penguins.jpg file in the "mycontainer" container, in the "chilkat" account.
    DECLARE @url2 nvarchar(4000)
    SELECT @url2 = 'https://chilkat.blob.core.windows.net/mycontainer/penguins.jpg?sv=2021-06-08&ss=bfqt&srt=sco&sp=rwdlacupiyx&se=2023-02-12T21:30:53Z&st=2023-02-12T13:30:53Z&spr=https&sig=HB8CoZiD7EJD1rQNIVnLl%2Bq7kyLcOCnSXR14TadBv6s%3D'

    EXEC sp_OAMethod @http, 'ClearHeaders', NULL
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'x-ms-blob-type', 'BlockBlob'

    -- Upload a JPG file
    EXEC sp_OAMethod @http, 'HttpFile', @success OUT, 'PUT', @url2, 'c:/qa_data/jpg/penguins.jpg', 'image/jpeg', @resp
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @resp
        RETURN
      END

    EXEC sp_OAGetProperty @resp, 'StatusCode', @statusCode OUT

    PRINT 'response status code: ' + @statusCode

    EXEC sp_OAGetProperty @resp, 'StatusText', @sTmp0 OUT
    PRINT 'response status text: ' + @sTmp0

    IF @statusCode = 201
      BEGIN

        PRINT 'Success.'
      END
    ELSE
      BEGIN

        PRINT 'Failed.'
      END

    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @resp


END
GO