December 3, 2011 at 6:40 am
Hi,
I have created a table with the following and inserted a row.
Create table dbo.Photo (ID int, DOB datetime, Photo varbinary(max))
-- Insert a jpg file into a table using OPENROWSET
INSERT INTO dbo.Photo (ID, DOB, Photo)
SELECT 1, '21 Jan 1974', BulkColumn
FROM OPENROWSET (Bulk 'D:\WallPapers\tree.jpg', SINGLE_BLOB) AS blob
Now I want to see the actual image. Can anyone please provide me a good link or tell me how I can view the images stored in SQL server?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
December 3, 2011 at 6:50 am
Now I want to see the actual image. Can anyone please provide me a good link or tell me how I can view the images stored in SQL server?
How To Display Images Stored in a BLOB Field
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy