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