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