Entry

How to insert images into SQL 7.0 ?

May 5th, 2006 07:40
Deepak Sharma, low, http://vyaskn.tripod.com

First of all, if possible, try not to stored images and other binary 
files in the SQL Server tables, as they slow things down. Instead, 
store a link (file path) to the file in the tables and let your 
applications directly access the files. But if you must store these 
files within SQL Server, use the text/ntext or image datatype columns 
and consider the following options:
SQL Server 7.0 and 2000 come with a utility called textcopy.exe. You 
can locate this file in the Binn folder under your SQL Server 
installation folder. Run this file from command prompt, and it will 
prompt you for required input
Use the GetChunk and AppendChunk methods of ADO Field object. MSDN has 
examples
Use the ADO Stream object
Use the Bulk Insert Image utility (BII) that ships with SQL Server 2000 
(Can be found at \Program Files\Microsoft SQL
Server\80\Tools\Devtools\Samples\Utils) 
Hope this helps
Deepak
http://www.blueappleonline.com