Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 To store and retrieve an image

Author  Topic 

amsqlguy
Yak Posting Veteran

89 Posts

Posted - 2008-10-21 : 09:17:28
Guys,

I have create table with ID and column testimage

CREATE TABLE IMAGE_TEST
(
ID INT IDENTITY (1, 1) NOT NULL,
TEST_IMAGE IMAGE
)

How do I insert an image in this table with DML sql statements is it possible? or does it have to be done using application code

Thanks

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-21 : 09:27:10
Its best to keep your images in a folder and insert the physical path into a column and then format it at your presentation layer. Ie webpage
Go to Top of Page
   

- Advertisement -