Images

When you have a column property set to image, does it link to or does it embed the image in the table?

Davids Learning

If you specify the coloumn as image, this simply means that you are storing binary data. The name image is sometime is bit misleading :-)

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||If you needed to store an image like a tiff,bitmap,jpeg, what would you use?|||

Hi !

If you are in SQL Server 2005, I would prefer the VARBINARY(MAX),as the IMAGE and the TEXT are tro be deprecated in further versions. If you are on SQL Server 2000, I would prefer using either the IMAGE or the TEXT (in common it makes no difference, because they are nearly implemented the same way, beside that the TEXT type has some extra function which on work on that type). In this case, as you appearantly will need no functions of the TEXT type, I would choose IMAGE.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de