Skip to content

Instantly share code, notes, and snippets.

@davidsheardown

davidsheardown/sp_add_image_to_SQL

Created November 2, 2021 09:49
Show Gist options
  • Save davidsheardown/0fab35746918f8aafd37113bbfa8924c to your computer and use it in GitHub Desktop.
Save davidsheardown/0fab35746918f8aafd37113bbfa8924c to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. davidsheardown created this gist Nov 2, 2021.
    18 changes: 18 additions & 0 deletions sp_add_image_to_SQL
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,18 @@
    CREATE PROCEDURE [dbo].[sp_add_image_to_SQL]

    @ImageId int,
    @ImageFilePath nvarchar(255)

    AS
    BEGIN
    SET NOCOUNT ON;

    DECLARE @sql_string nvarchar(max) =
    N'UPDATE tbl_ext_product_images
    SET [Image] = (SELECT BulkColumn
    FROM Openrowset(Bulk ' + quotename(@ImageFilePath,nchar(39)) + ', Single_Blob) ImageData)
    WHERE Id = @ImageId';

    EXECUTE sp_executesql @sql_string, N'@ImageId bigint', @ImageId

    END