How can we Update Image in SqlServer Ce???

• sivak42

  SSC Veteran

  Points: 243

  More actions

  April 4, 2008 at 3:56 am

  #188771

  Hi guys,

  I would lilke know.I have a column called Image in the database. The type of of the column is Image. I want to upade it. I have an jpg file. How can do that????

  Lets say I can retrieve an image file from url,

  then save it into the sql server ce.....

  not insert ...i want to update...

  Thank you

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  April 12, 2008 at 3:06 pm

  #801828

  Try this

  UPDATEt

  SETt.Img = s.Img

  FROMMyTable AS t

  INNER JOINOPENROWSET(BULK N'C:\Image1.jpg', SINGLE_BLOB) AS s(Img)

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• max 23838

  SSC Journeyman

  Points: 84

  More actions

  June 16, 2011 at 10:41 am

  #1339903

  Another syntax worked better for me. I had added a Picture column to a table ([font="Courier New"]Model[/font]), and wanted to update existing rows in the table with images from files - in this case [font="Courier New"]Picture.jpg[/font]. The kicker was realising that you needed 2 aliases (PictureTable and blob).

  WITH PictureTable AS (SELECT blob.* FROM OPENROWSET(BULK N'C:\Picture.jpg', SINGLE_BLOB) AS blob)

  UPDATE Model

  SET Model.Picture = PictureTable.BulkColumn

  FROM Model, PictureTable

  WHERE Model.Id = 2;

• max 23838

  SSC Journeyman

  Points: 84

  More actions

  June 17, 2011 at 12:10 am

  #1340195

  ...or even more succinctly:

  UPDATE Model

  SET [Picture] = (SELECT MyImage.* from Openrowset(Bulk 'C:\cartridge1.jpg', Single_Blob) MyImage)

  WHERE Id = 9