Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)