Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Location
    Dresden, Germany
    Posts
    31

    Question Unanswered: How to SELECT a BLOB image?

    Hi!

    Can anyone help me how to select a BLOB image in Sql Server 2008 directly in SSMS? I know it must be done with FILESTREAM, but how I can do that directly and not to write a special program? For C# I found that: Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server 2008

    Thank you in advance.
    sp00ky

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Using SSMS you will not be able to see the image, but you can select the hexadecimal equivalent. In order to see an image, you will need to develop something that can display images.

  3. #3
    Join Date
    Jun 2007
    Location
    Dresden, Germany
    Posts
    31
    OK, so I have to write a small C# app...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •