How to store image in SQL Server database tables column

image, sql, sql-server, t-sql

Solution

give this a try,

insert into tableName (ImageColumn) 
SELECT BulkColumn 
FROM Openrowset( Bulk 'image..Path..here', Single_Blob) as img

INSERTING

REFRESHING THE TABLE

Problem

I Have a table named `FEMALE` in my database. It has `ID` as `Primary Key`, it has an `Image` column. My Question is how do I store an image using a SQL Query?

Original source

Related problems