Home Forums SQL Server 2005 SQL Server 2005 Compact Edition How can we Update Image in SqlServer Ce??? RE: How can we Update Image in SqlServer Ce???
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