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 |
|
MightyAC
Starting Member
5 Posts |
 Posted - 2006-10-20 : 08:47:55
|
| I am having problems updating a text field with a very large string.If I build a string in code using a string variable and then update 1 row I have no problem. However, I want to run an update statement that hits many rows. When I run the stored proc that does this my string is being truncated near 3,800 characters.Here's an example of what I'm trying to do. BigString is a TEXT field.Update Table1 Set BigString = 'blah, blah, blah ' + Table1.Field1 + ' blah, blah, blah ' + Table2.Field1, etc..From Table1 Inner Join Table2 On ....My guess is because the actual string builds on the fly that SQL engine stores it in some temporary nVarChar like structure and it runs out of space. So far my solution has been to split the big string across many fields. This will work but it is not at all practical. Any possible work arounds or solutions would be appreciated. Thanks in advance. |
|
|
|
|
|
SQL 2000 Text Field Problem