0 out of 1 rated this helpful - Rate this topic

Adding ntext, text, or image Data to Inserted Rows

SQL Server 2005

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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions