Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-27 : 16:04:27
|
| krishna writes "Hi,I am a DBA, and I have a SP where I get a string of type NTEXT. (Size>42000 bytes). Ntext string get the list of id's(PK values) to be copied from one region to another region. eg- Car spare parts list to be copied from country US to UK. I send the spare part id's list.I am spliting the NTEXT into a temp table and the using a cursor to loop through each PK and copy its details to new region. The temp table is copying upto 8000 bytes and them failing after that? Is there a way to copy all the NTEXT string , seperated data (> 8K) into a temp table?Thanks,Kris." |
|
|
|
|
|
NTEXT string operation