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

Concepts

Adding Rows by Using INSERT and SELECT
Adding a Row by Using a Result Set Position
Adding Rows by Using Bulk Copy Operations

Other Resources

UPDATETEXT (Transact-SQL)
INSERT (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance