How To Inset an jpg file into the Image datatype

[C0PP3R]

I have a table with an ID and an Image datatype and I'm trying to insert a jpg file into the image field. Does anyone know the SQl syntax to do this.

Muchly appreciated as always

Copper

 

[JamesLean]

Best advice - don't do this! Trying to store the actual image in the database will lead to all sorts of problems and will not perform well.

Instead, store the images in a folder and simply store the path to the image in a varchar field in your DB. --James

 

[C0PP3R]

I've heard that many times before, although the DB I'm working in was set up by someone else, and to retain functionality for the time being I need to insert one jpginto the DB, Anyone know the SQL code for inserting a jpg into an image datatype field?

Thanks Again

Copper

 

[sunila7]

Hi,

have a look at this link.... does this help

http://beta.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20321610.html

Sunil