Please help! Insert a picture in an MS SQL Server table

Please help! Insert a picture in an MS SQL Server table
How can u insert a picture an an image field in SQL server table? Is it
possible from SQL server tools or other tools, programming?What programming language are you using ?
jens Suessmeyer.|||De kess (Dekesse@.anonyme.com) writes:
> Please help! Insert a picture in an MS SQL Server table
> How can u insert a picture an an image field in SQL server table? Is it
> possible from SQL server tools or other tools, programming?
Yes, this is possible. Unless the pictures are small, you would use
the image data type on SQL 2000 and the data type binary(MAX) in SQL 2005.
You would do this programattically. There is no tool that permits you
just paste in the picture, at least not that comes with SQL Server. There
could be third-party tools out there.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||txs for your answer
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns9761E07E5FF89Yazorman@.127.0.0.1...
> De kess (Dekesse@.anonyme.com) writes:
> Yes, this is possible. Unless the pictures are small, you would use
> the image data type on SQL 2000 and the data type binary(MAX) in SQL 2005.
> You would do this programattically. There is no tool that permits you
> just paste in the picture, at least not that comes with SQL Server. There
> could be third-party tools out there.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx