Insert image into SQL Server [duplicate]
you can try like this
CREATE TABLE ImageTable( Id int, Name varchar(50) , Photo varbinary(max) )INSERT INTO ImageTable (Id, Name, Photo) SELECT 1, 'test', BulkColumn FROM Openrowset( Bulk 'C:\test.jpg', Single_Blob) as image