Hi, I'm new using SQL Server, I've bougth the book Beginning SQL Server Programming from Wrox. Now, my question for the experienced people is: How can I insert or pass an image object to my database? Thanks in advance.



MAKO - "El super simio"

__________________
MAKO - \"El super simio\"

For SQL 2005 it is recommended that you use a varbinary(max) datatype to store it. You could also use an image data type.

So you can create a table with one of these datatypes and then a storedprocedure with the same datatype. Then call the stored procedure from your client side code and pass in the bits you want to store.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com