How to store image in SQL Server database tables column

Question

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?

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

Comments

[VINNUSAURUS]

Please explain what is bulkcolumn ?

[John Woo]

bulkcolumn is part of the syntax.

[VINNUSAURUS]

I Tried this INSERT INTO Female (Image) SELECT BulkColumn FROM Openrowset(BULK 'E:\Vinay\New Folder (2)\ileana00002.jpg ',Single_Blob)as img , but it is giving error Msg 515, Level 16, State 2, Line 1 Cannot insert the value NULL into column 'ID', table 'PMB.dbo.Female'; column does not allow nulls. INSERT fails. The statement has been terminated.

[John Woo]

the reason for that is your column ID is a NON_NULLABLE column. is it an integer column and set as identity? if not, then you need to specifically define column in your INSERT statement.

[VINNUSAURUS]

Please show me how to do that iam new to SQL and i need it immediatly.

[VINNUSAURUS]

my ID column is PK and incriments 1 on each entry

[VINNUSAURUS]

OOPS THANK YOU it worked :D i did not set identity incriment and seeding property for auto incriment, but it worked thanks for the help :)

[VINNUSAURUS]

Can you please show me how to insert other column Details too with the above query, that is with the image how to insert into other rows at the same time ?

[John Woo]

see here

[Ads]

@JW웃 what is the format its stored in the image column? is it Base64 or any other format?

[Ali.Rashidi]

when I use WHERE in the query to insert image to specified rows it does not recognize table column names. why?

[dosaki]

The path needs to be local to the machine holding SQL Server