Image

• bruce_reid

  SSCrazy

  Points: 2419

  More actions

  August 4, 2003 at 2:35 pm

  #82499

  How can I store an imgage(.Jpg or .bmp file)in my sql server table.Which datatype i should use and how can store it in my database table.

  Thanks in advance.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  August 4, 2003 at 11:40 pm

  #468571

  Hi Bruce,

  quote:

  ---

  How can I store an imgage(.Jpg or .bmp file)in my sql server table.Which datatype i should use and how can store it in my database table.

  ---

  I use the image data type for this.

  Although there are also 'pure' SQL Server ways to do this, I use the ADO Stream Object like explained here http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=12228

  HTH

  Cheers,

  Frank

  Edited by - a5xo3z1 on 08/04/2003 11:41:24 PM

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]