SQLTeam.com | Weblogs | Forums

Retrieve image


#1

Hi folks,

Probably easy but my morning coffee just doesn't seem to help.

I'm saving an image in a SQL image field as so:
Update MyTable set MyImg = (SELECT BulkColumn FROMOPENROWSET(BULK N'C:\Test.png', SINGLE_BLOB) AS x) where id = 1

  1. But now, if ever one day the C:\Test.png image needs to be re-created from the stored data, how do I do it?
  2. What if, instead of using a file like C:\Test.png, I want to store a binary array containing the data of this image, what would be the equivalent syntax to the Update statement above and how could I retrieve it and re-create a binary array?

Thanks folks!!!