Image storing

How do i store an image in the db?

I guess i have to chose image as the type of the column.

Do i really need to build an application that will fetch the image and put it in a query?

or can i use directly use sql server management studio?

thanks,If you are on SQLServer2005 you should better choose VARBINARY(MAX), IMAGE and Text will be deprecated in the future. YOu have to use an application which will convert the physical file to the actual byte array.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens Suessmeyer wrote:

If you are on SQLServer2005 you should better choose VARBINARY(MAX), IMAGE and Text will be deprecated in the future. YOu have to use an application which will convert the physical file to the actual byte array.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Do you know an application that will convert the file to actual byte? or i have to code it ?|||Hi,

thats realllllyy easy, have a look at this snippet:

http://www.codeproject.com/aspnet/PicManager.asp

HTH; jens SUessmeyer.

http://www.sqlserver2005.de