> Can i put picture in sql server database but not filename and path. I want
> to put complete picture in field in database. Is it possible?

> Igor (igor@nesalji.hr) writes:
> > Can i put picture in sql server database but not filename and path. I
want
> > to put complete picture in field in database. Is it possible?
>
> Yes, this is possible. If you are on SQL 2005 use the varbinary(MAX)
> datatype, if you are on SQL 2000 you need to use the image data type.
> "image" is on SQL 2005 as well, but is deprecated.
>
> I have a very simple example on how to work with blobs (binary large
> objects) through ADO .Net on http://www.sommarskog.se/blobload.txt.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx