InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 13:05:13 GMT20http://www.sqlservercentral.com/Forums/Topic479795-323-1.aspx...or even more succinctly:[color=#0000FF]UPDATE[/color] ModelSET [Picture] = ([color=#0000FF]SELECT[/color] MyImage.* from Openrowset(Bulk 'C:\cartridge1.jpg', Single_Blob) MyImage)[color=#0000FF]WHERE[/color] Id = 9Fri, 17 Jun 2011 00:09:59 GMTmax 23838http://www.sqlservercentral.com/Forums/Topic479795-323-1.aspxAnother 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 ModelSET Model.Picture = PictureTable.BulkColumnFROM Model, PictureTableWHERE Model.Id = 2;Thu, 16 Jun 2011 10:41:15 GMTmax 23838http://www.sqlservercentral.com/Forums/Topic479795-323-1.aspxTry this[code]UPDATE tSET t.Img = s.ImgFROM MyTable AS tINNER JOIN OPENROWSET(BULK N'C:\Image1.jpg', SINGLE_BLOB) AS s(Img)[/code]Sat, 12 Apr 2008 15:06:08 GMTSwePesohttp://www.sqlservercentral.com/Forums/Topic479795-323-1.aspxHi 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 youFri, 04 Apr 2008 03:56:02 GMTsivak42