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 |
|
holzert
Starting Member
9 Posts |
 Posted - 2011-09-01 : 21:19:35
|
| All,If I have a text column and a user will be appending text to it via odbc, I don't want to pull down all of the text, append to it, and then push it all back up. I am trying to find a means of just passing in the new data to be appended to the value already in the column. The column could have greater than 8000kb in it and the data to append to the column could be greater than 8000kb as well.Some customers have 2000, some 2005, and some 2008 so I'm looking for a solution for all. Right now the issue is of course the 2000 customers....(Please don't recommend upgrading all customers to 2005+)Is updatetext the only option and if so, does it support > 8000kb?Thanks in advance,. · * ´ ¨ ) .· ` T C H ( . . · * |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-02 : 00:52:59
|
| i dont think updatetext has limit of 8000 for data to be appended. you can even merge another text field value. only thing is total length shouldnt go beyond text field size limit------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
holzert
Starting Member
9 Posts |
Posted - 2011-09-02 : 07:53:06
|
| Thank you! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-02 : 08:02:25
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Append data (possibly > 8000kb) to SQL Server 2000