Managing ntext, text with a long text data

Hi,
I have a problem to insert(update) a long text (more than 64K) into
SQL 2000 (datatype - 'text'). It cuts the data and insert only 64K.
MSDN says: "When the ntext, text, and image data values get larger,
however, they must be handled on a block-by-block basis. Both
Transact-
SQL and the database APIs contain functions that allow applications to

work with ntext, text, and image data block by block." Could somebody

give me an example how to do this, please.
Thank you

.

Relevant Pages

  • Re: Managing ntext, text with a long text data
    ... "When the ntext, text, and image data values get larger, ... I believe this limitation is in the client API rather than in T-SQL ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Question for Mike Williams... please need help
    ... I also need to export pictures and lines. ... you can store the lines in a separate array of UDTs. ... you could save each image data block, one after the other, in a file using ...
    (microsoft.public.vb.general.discussion)
  • Re: Trigger special tables
    ... To be more precise (my question about text, ntext, image): ... Can be done something within SQL server, ... > INSERTED and DELETED are only availible in the scope of the trigger. ... >> that it's not possible to read text, ntext and image data from these ...
    (microsoft.public.sqlserver.programming)
  • Update text filed error
    ... SQL 2000 ... The text, ntext, and image data types are invalid in this subquery or ... aggregate expression. ...
    (microsoft.public.sqlserver.programming)
  • RE: error: saving to a ntext column becomes corrupted (???)
    ... when ntext, text and image data values are larger than 8k they are stored outside the data page for the row via a pointer. ... see sql books on line for more info under managing ntext, text, and image data ...
    (microsoft.public.sqlserver.programming)