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 Using 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.

See Also