question

user-806 avatar image
user-806 asked

Image Data type

Hi,

I have a table in which one column is image data type & data is already there.

Now when in running selcet query,its retuen value in hexadecimal code.

Actually i want actual image.

So can any body tell me how can i query so that i get the image in management studio.

If it is not possible then any other option???

ssmsdatatypes
10 |1200 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

· Write an Answer
Yeoh Ray Mond avatar image
Yeoh Ray Mond answered

Hi, I wrote SQL Image Viewer, and it will do what you need, which is to display any images (gif, jpg, png, bmp, tif, ico, psd etc) retrieved by your query. It identifies the image type from the image data itself. In addition, it'll also identify most types of binary data that may be returned by your query e.g. pdf, xls, doc, zip, bz2, gz, wav, mp3, etc. It can also export your image and binary data to disk.

Give the trial version a run and if you have any further questions, just ask.

Thanks.

10 |1200 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered

you wont get an image to be rendered in SSMS, its not that sort of interface, you'll have to use the image datatype in an application and use the control there to display the image.

10 |1200 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tom Staab avatar image
Tom Staab answered

I did a search and was surprised I couldn't find a free SQL query image viewer. I found this shareware version, but I don't know how good it is: http://www.sqlimageviewer.com/

10 |1200 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.