471,594 Members | 1,589 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,594 software developers and data experts.

SQL 2000 Text Field Problem

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.

Any possible work arounds or solutions would be appreciated. Thanks in advance.
Oct 18 '06 #1
0 1855

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Michael Bulatovich | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by Anwar ali | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.