DanielaTm
May 25th, 2006, 10:53 AM
Does anyone know if it is possible to load in a stored procedure (sql server express edition) some gif files form harddisk and insert them into a table?
thanks,
thanks,
Click to See Complete Forum and Search --> : load image
Igor Soukhov
May 28th, 2006, 08:00 PM
Does anyone know if it is possible to load in a stored procedure (sql server express edition) some gif files form harddisk and insert them into a table?
thanks,
*Create a table with two columns - one varchar to store the name of the file, another column of type IMAGE - to store an image data.
*Create the sproc that accepts two parameters - file name and image data.
The implementation of the sproc might be very 'passthrough' simple - inserting data from input parameters into the table.
*In client code load image file from a disk into array of bytes. Pass this array along with a filename to the sproc.
ps: Proposed implementation of the sproc is very simple, and doesn’t take into account any considerations (like error handling, resolving of filename collision, etc).
thanks,
*Create a table with two columns - one varchar to store the name of the file, another column of type IMAGE - to store an image data.
*Create the sproc that accepts two parameters - file name and image data.
The implementation of the sproc might be very 'passthrough' simple - inserting data from input parameters into the table.
*In client code load image file from a disk into array of bytes. Pass this array along with a filename to the sproc.
ps: Proposed implementation of the sproc is very simple, and doesn’t take into account any considerations (like error handling, resolving of filename collision, etc).
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.
Copyright Internet.com Inc., All Rights Reserved.