-- =============================================

-- Creates a record in the Images table

-- =============================================

ALTER PROCEDURE storeProductImage

      @ImageTitle varchar(MAX),

      @ImageType varchar(MAX),

      @ImageData varbinary(MAX),

      @ImageLength bigint,

      @ProductNumber varchar(50)

 

AS INSERT INTO Images VALUES (@ImageTitle, @ImageData, @ImageType, @ImageLength, @ProductNumber)