Insert Script for image in sql server2000

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi all, do you have any idea about Inserting image using script in sql server2000. Thanks in adv. Jai

-- Anonymous, January 27, 2005

Answers

Jayakumar,

These are ways to add ntext, text, or image values to a row:

Specify relatively short amounts of data in an INSERT statement in the same way char, nchar, or binary data is.

It is possible to bulk copy a data file as ntext, text, or image data into an instance of SQL Server.

Use the WRITETEXT statement.

ADO applications can use the AppendChunk method to specify long amounts of ntext, text, or image data.

OLE DB applications can use the ISequentialStream interface to write new ntext, text, or image values.

ODBC applications can use the data-at-execution form of SQLPutData to write new ntext, text, or image values.

DB-Library applications can use the dbwritetext function.

Hope this helps,

Eric

-- Anonymous, January 27, 2005


Moderation questions? read the FAQ