WRITETEXT

SQL Server

Example

UPDATE Document
SET Text = "NEW TEXT"
WHERE Title = "title1";

WRITETEXT Document.Text "NEW TEXT"

Output

Command(s) completed successfully.

Explanation

In this example, WRITETEXT is used to update a specific Text column in the Document table. The Text column’s value for the row where the Title is ‘title1’; is changed to ‘NEW TEXT’.