SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 08:49 AM
| ||||
| ||||
 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. Bot Transact SQL and the database APIs contain functions that allow applications t work with ntext, text, and image data block by block." Could somebod give me an example how to do this, please Thank yo      |
|
02-29-2008, 08:49 AM
| |||
| |||
| Re: Managing ntext, text with a long text data There are examples under UPDATETEXT and WRITETEXT in Books Online - do these cover what you're trying to do? The MSSQL Resource Kit also has a whole chapter on working with BLOBs, including a number of examples using TSQL and ADO: http://www.microsoft.com/technet/pro...rt3/c1161.mspx Simon |
|
02-29-2008, 08:50 AM
| ||||
| ||||
| Re: Managing ntext, text with a long text data igorsl (igorsl@yahoo-dot-com.no-spam.invalid) 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@sommarskog.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp |
Linear Mode
