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