Insert image into SQL Server [duplicate]

Question

I want to insert in a table an (image , id, Code) but I don't know how to do this .

What I am looking for is how to insert an image not url.

I posted my question with an answer here, if anyone needs to know how to do this in a Windows Form: stackoverflow.com/q/33962272/153923 — user153923
– user153923, Commented Nov 27, 2015 at 17:46

Pranay Rana · Accepted Answer · 2014-02-06 10:36:41Z

23

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

answered Feb 6, 2014 at 10:36

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mitsu Over a year ago

but if i put url of the image for exemple in my DD 'D' in a folder ' myimages' , and when the user take this application in the futur he will have a problem whith the path of the image no?

abdou_dev Over a year ago

what if is stored procedure ? how can I do that?

Collectives™ on Stack Overflow

Insert image into SQL Server [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related