| Alvin Zhao[MS] 2002-10-05, 9:09 pm |
| You can use WRITETEXT, READTEXT and UPDATETEXT in T-SQL to write data to,
read data from and update data in text, ntext and image columns. Use
WRITETEXT to replace text, ntext, and image data and UPDATETEXT to modify
text, ntext, and image data. UPDATETEXT is more flexible because it changes
only a portion of a text, ntext, or image column rather than the entire
column. You can use READTEXT to read text, ntext, or image values from a
text, ntext, or image column, starting from a specified offset and reading
the specified number of bytes.
Sincerely,
Alvin Zhao
Microsoft Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
|