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 2000 Forums
 SQL Server Development (2000)
 Storing images in SQL Table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-07 : 07:28:29
Gautam writes "Please tell me how to insert images in SQL table and which datatype should be used while creating a field for storing images.

Please provide me with the query for the same."

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-06-07 : 07:43:22
You shouldn't insert images into SQL Tables. You should store them on a file system and store a pointer to them in the database. If you want to know how to store images in SQL Server though, www.asp.net has a good article about it on their site.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -