Re: Managing ntext, text with a long text data
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 25 Aug 2005 21:52:03 +0000 (UTC)
igorsl (igorsl@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx) writes:
> 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.
I believe this limitation is in the client API rather than in T-SQL
itself. (Altough inserting a 1MB value through a plain INSERT is not
that performant.) Which API are you using?
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.
- References:
- Managing ntext, text with a long text data
- From: igorsl
- Managing ntext, text with a long text data
- Prev by Date: Re: Stored procedure error handling
- Next by Date: Web Survey database design
- Previous by thread: Re: Managing ntext, text with a long text data
- Next by thread: SQL Reporting Services Passing parameters
- Index(es):
Relevant Pages
|
