x

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

more ▼

asked Mar 09 '10 at 08:47 AM in Default

user-806 gravatar image

user-806
181 16 18 21

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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.

more ▼

answered Mar 10 '10 at 10:58 PM

Yeoh Ray Mond gravatar image

Yeoh Ray Mond
61

That's a nice tool. Are those the Yeoh Ray Mond offspring eating snacks in the screen cast? Very cute :)
Mar 10 '10 at 11:46 PM KenJ
Thanks. Yes, those are my kids. Time sure flies.
Mar 11 '10 at 03:02 AM Yeoh Ray Mond
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Mar 09 '10 at 08:56 AM

Fatherjack gravatar image

Fatherjack ♦♦
41.3k 73 77 107

(comments are locked)
10|1200 characters needed characters left

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/

more ▼

answered Mar 09 '10 at 10:38 PM

Tom Staab gravatar image

Tom Staab
5.8k 6 8 10

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x123
x35

asked: Mar 09 '10 at 08:47 AM

Seen: 1982 times

Last Updated: Mar 09 '10 at 11:51 AM