September 1, 2011 at 7:25 pm
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....but we need a solution for 2000-2008...
Is updatetext the only option and if so, does it support > 8000kb?
Thanks in advance,
. · * ´ ¨ ) .· ` T C H ( . . · *
September 2, 2011 at 2:08 am
in actual fact I suspect what you're trying to avoid may be the best method . e.g. less complexity. I seem to remember there were a bunch of commands for text data which do as you wish, a quick check shows these should not be used any more ( writetext, readtext ) and you should use .WRITE (expression,@Offset,@Length) in the update statement. http://msdn.microsoft.com/en-us/library/ms177523.aspx
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
September 2, 2011 at 5:53 am
Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply