view image stored in sql server

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

  • 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

    http://support.microsoft.com/kb/173308

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply