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 |
|
SucharithaVenna
Starting Member
2 Posts |
 Posted - 2009-06-22 : 06:49:23
|
| I have a column which is of type NTEXT. I will have to update the value of the column very regularly. When I use, UPDATE command, the text is truncated (not sure of the reasons). I find the WRITETEXT command updating the entire text to completion. For few of the records, I now observe that the column text contains single codes (') in it. But the WRITETEXT command does not allow me to insert the single codes (') into the text using the string congatenation method ('''+') as i do for the other VARCHAR columns using UPDATE.Urgently need help with this, as I need to put things to live site ASAP.Thanks,Sucharitha |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-22 : 10:50:37
|
| you can escape single quotes by preceding it with an extra quote. see belowhttp://sqlblogcasts.com/blogs/madhivanan/archive/2008/02/19/understanding-single-quotes.aspx |
 |
|
|
SucharithaVenna
Starting Member
2 Posts |
Posted - 2009-06-22 : 12:12:14
|
| Yes, that is working. Thanks for the great clue.Thanks,Sucharitha |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-22 : 12:18:03
|
| welcome |
|
|
|
|
|
|
Need help using WRITETEXT command