View Single Post
  #2 (permalink)  
Old September 8th, 2006, 04:44 PM
David_the_DBA David_the_DBA is offline
Friend of Wrox
 
Join Date: Dec 2005
Location: , AZ, .
Posts: 146
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
Reply With Quote