p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2005 (http://p2p.wrox.com/forumdisplay.php?f=220)
-   -   inserting image data type object (http://p2p.wrox.com/showthread.php?t=47569)

MAKO September 8th, 2006 11:10 AM

inserting image data type object
 
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"

David_the_DBA September 8th, 2006 04:44 PM

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


All times are GMT -4. The time now is 03:39 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.