Adding ntext, text, or image Data to Inserted Rows

You can add ntext, text, or image values to a row in the following ways:

Specify relatively short amounts of data in an INSERT statement in the same way char, nchar, or binary data is.
Use WRITETEXT.
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. For more information, see BLOBs and OLE Objects.
ODBC applications can use the data-at-execution form of SQLPutData to write new ntext, text, or image values. For more information, see Managing Text and Image Columns.
DB-Library applications can use the dbwritetext function. For more information, see Text and Image Functions (Transact-SQL).

See Also