Name of tool for insert images in sql server

Question

Post reply

Name of tool for insert images in sql server

forsqlserver

SSCoach

Points: 18902
More actions
November 25, 2008 at 2:54 am

#203314

Dear all
Is there any online free tool for inserting image in sql server 2005
Thanx
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

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

Mike John SSCertifiable Points: 7216 More actions · Answer 1

Do you need a tool - you can do it in SQL?

Assuming a table called images that looks a bit like this:

create table images (

image_id integer identity primary key,

image_name varchar(20),

image_value image)

and it has one row like this:

insert into images(image_name) values ('my picture')

then this will put the image data from a file called 'c:\logo.png' into the image_value column of the row just inserted.

update images set image_value = (select bulkcolumn

FROM OPENROWSET (BULK 'c:\logo.png' ,

SINGLE_BLOB) BlobData)

where image_id = 1

I wish I could credit the original source of this - but I found it a while ago and no longer recall where.

Mike John

forsqlserver SSCoach Points: 18902 More actions · Answer 2

Dear John,

Thanx it's working.

You have solved my issue,Can u help me how to extract the image data from table.

Thanx

Ajay

Thanks

Timothy J Hartford SSCarpal Tunnel Points: 4214 More actions · Answer 3

The image can be "extracted" using a simple SELECT statement... the question is, extracted for what? Where is this image being used? I have a .Net web service that I wrote that I can request an image by ID and it will return a stream of the image (allowing me to use the URL for the web service as an Image URL in other apps). I have also written programs that directly pull in the image as a blob, and I have written an SSRS report to display images. All of which are a little different.

Akalya Valued Member Points: 69 More actions · Answer 4

Hi,

This was quite useful. I want to use this in the cube. In the cube browser, selecting this attribute, should show me the image. So that any third party reporting tools should be able to access this image from the cube and display it. like in excel, when we select this attribute, the image should get displayed. Is it possible? How do we achieve this?

- Akalya.