WRITETEXT table-name.column-name
text-pointer [ WITH LOG ] data

Updates an existing column value. The update is not recorded in the transaction log, unless the WITH LOG option is supplied. You cannot perform WRITETEXT operations on views.

None.

WRITETEXT does not fire triggers, and by default WRITETEXT operations are not recorded in the transaction log.

• READTEXT statement [T-SQL]
• TEXTPTR function [Text and image]

The following embedded SQL code fragment illustrates the use of the WRITETEXT statement. The SELECT statement in this example returns a single row. The example replaces the contents of the Description column on the specified row with a new value.

EXEC SQL create variable txtptr binary(16);
EXEC SQL set txtptr =
    ( SELECT textptr(Description)
        FROM MarketingInformation
        WHERE ProductID = '500' );
EXEC SQL writetext MarketingInformation.Description
   txtptr 'newdata';