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)