Viewing 2 posts - 1 through 2 (of 2 total)
...or even more succinctly:
UPDATE Model
SET [Picture] = (SELECT MyImage.* from Openrowset(Bulk 'C:\cartridge1.jpg', Single_Blob) MyImage)
WHERE Id = 9
June 17, 2011 at 12:10 am
#1340195
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...
June 16, 2011 at 10:41 am
#1339903