By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,203 Members | 1,560 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,203 IT Pros & Developers. It's quick & easy.

Questions on inserting jpeg image into SQL table

P: 93
Hiya,

Can anyone help me in this..i'm stuck

I have created a table in SQL server that contain field name (shotSelectedKeyfrm -int type, and imgSelectedKeyfrm-varchar(255) type) like below:

Column1 Column2
[shotSelectedKeyfrm] [imgSelectedKeyfrm]
32
340
989




I want to insert the path link in the second column (imgSelectedKeyfrm) which direct to the location where I store my jpeg image in my server folder c:\...\imagefolder\ . How do I insert that image in the column faster? I have 1000 over number of rows in the table.

The related image filename are same to the first colum say (32.jpg, 340.jpg, 989.jpg and so on).

Should I store image directly in the table above or just store the path link? Which is better/faster for retrieval later on?

Thanks
Aug 21 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.