how to insert images in to image table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » how to insert images in to image table

how to insert images in to image table

Rate Topic

Display Mode

Topic Options

Author

Message

miriyalasrihari

Posted Saturday, February 19, 2011 3:30 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, June 14, 2012 11:52 PM
Points: 63, Visits: 257

how to insert images in to image table through query

i created one table like..
CREATE TABLE [dbo].[image](
[image2] [varbinary](50) NULL,
[id] [int] NULL
)

GO

i don't know how to insert/retrieve images through query...
Please give some example query..

in my system
MS SQL SERVER 2008 Enterprise Edition.....

Thanks in advance....

SRIHARI(:~

Post #1066764

ksjayadev

Posted Saturday, February 19, 2011 4:49 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 4:13 AM
Points: 11, Visits: 858

Try this

insert into image (image2,id)
select Bulkcolumn from openrowset (bulk 'path of image file', single_blob) as picture,1

Post #1066766

diamondgm

Posted Saturday, February 19, 2011 6:33 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:32 AM
Points: 136, Visits: 770

Hi,

My 2c...

1. I am concerned that varbinary(50) may not be sufficient storage space.
2. Depending on usage, you may want to check out FILESTREAM if you are using sql server 2008.

I cannot verify syntax.

Good luck!

Post #1066775

« Prev Topic | Next Topic »

Permissions