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 |
|
aoifey123
Starting Member
4 Posts |
 Posted - 2008-06-12 : 12:01:16
|
I know that similar items have been posted before but I have not found a solution to my issue by reading them. I have a text field which holds amendment details and it cannot be updated through QA. I have 50 records which I have had to manually update through Enterprise Manager. I have been able to edit the amendment details field of 48 of these records. However for 2 records the amendment details field contains <long text> and as we all know, there does not seem to be an easy way to edit these.Before I give up for good, does anyone have any suggestions?Help much appreciated.  |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-12 : 12:49:29
|
| This should provide you some help:-http://www.sqlservercentral.com/articles/Miscellaneous/handlingthetextdatatype/985/ |
 |
|
|
aoifey123
Starting Member
4 Posts |
Posted - 2008-06-13 : 04:22:05
|
| thank you, the article helped a lot |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-13 : 04:34:43
|
quote:
Originally posted by aoifey123
thank you, the article helped a lot
You're welcome  |
|
|
|
aoifey123
Starting Member
4 Posts |
Posted - 2008-06-13 : 09:12:36
|
| sorry, but i spoke too soon. using substring allows me to view what is in the long text field but I can't edit it in this way :( |
|
|
|
aoifey123
Starting Member
4 Posts |
Posted - 2008-06-18 : 10:14:54
|
| anyone else have any ideas??? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-18 : 10:17:05
|
quote:
Originally posted by aoifey123
anyone else have any ideas???
Did you read about UPDATETEXT command in article? |
|
|
|
|
|
|
how to edit <long text> field