Adding ntext, text, or image Data to Inserted Rows

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.
Use the WRITETEXT statement. For more information, see WRITETEXT.
ADO applications can use the AppendChunk method to specify long amounts of ntext, text, or image data. For more information, see Managing Long Data Types.
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.