Image Data Type

  • Hi

    I've one table called 'Customer' and the columns are Cust_id Char(4), Photo IMAGE data type.

    I want to insert one image, JPEG format, from my Hard drive 'D' to SQL database. I need to insert for our each customer. Plz suggest how to insert and view it?

    Amit

  • This was removed by the editor as SPAM

  • You would need a client that is written in some language that understands how to read jpg files from a disk and can send it off to be inserted in the table.  Once the client reads the file, it's just another chunk of data to SQL Server.  So do you have VB or C# laying around?

    There is no "i" in team, but idiot has two.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply