Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need help using WRITETEXT command Expand / Collapse
Author
Message
Posted Monday, June 22, 2009 5:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 22, 2009 10:12 AM
Points: 2, Visits: 7
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.

Ultimately, I need to be able to update the column values with large text having single codes ('). Please help/suggest.

Urgently need help with this, as I need to put things to live site ASAP.



Thanks,
Sucharitha
Post #739299
Posted Monday, June 22, 2009 10:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 22, 2009 10:12 AM
Points: 2, Visits: 7
We can escape single quotes by preceding it with an extra quote. see below

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/02/19/understanding-single-quotes.aspx
Post #739549
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse