add image to sql table

Question

Transact SQL

There is a database with the name ProductPicture
, you need to fill in the Picture field with a request, which contains a binary array of the picture. I'm trying with this query

UPDATE ProductPicture SET ProductPicture.Picture =  CONVERT(varbinary(MAX), 'C:\1.jpg')

but this is followed by a message about a successful query, but the database is still empty.
Question: how can I load a file (picture) into a cell from sql managemet?

Answer 1

OPENROWSET .
Question author's solution:

UPDATE PictureProduct 
SET Picture = 
      (SELECT * FROM OPENROWSET(BULK N'C:\1.jpg', SINGLE_BLOB) AS image)
WHERE Id = 6

INSERT INTO PictureProduct (Id, IdProduct, Picture) 
SELECT 8, 4, BulkColumn 
FROM Openrowset( Bulk 'C:\2.jpeg', Single_Blob) as image