Posted by ciroteo � on 01/10/07 17:27

"Erland Sommarskog" <esquel@sommarskog.se> ha scritto nel messaggio
news:Xns98A7F0EE37B83Yazorman@127.0.0.1...
> 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



Talking about pictures, I saw you from your website came in Italy in 2006
....
did you like it?
greetings from Milan

• Next in forum: Re: giving a proc database and table names as parameters
• Prev in forum: Re: giving a proc database and table names as parameters
• Thread view: [OT}Re: Picture in database

[Reply to this message]