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???

  • 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