[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Update <long text> column in SQL Srvr databse

Posted on 2009-02-11
4
Medium Priority
?
483 Views
Last Modified: 2013-12-03
I need to update a long text column in a SQL server database. The text that has to be updated is a script and has a lot of single quotes( ') in them. Any help is appreciated...
0
Comment
Question by:Ravishanka
  • 2
3 Comments
 
LVL 25

Expert Comment

by:reb73
ID: 23614565
Is the script already stored in a variable or column or do you have to update it as a literal value?
0
 

Author Comment

by:Ravishanka
ID: 23614941
It is not in a variable, we have to update it as a literal value.
0
 
LVL 25

Accepted Solution

by:
reb73 earned 500 total points
ID: 23615088
In that case just do a find and replace to replace all instances of single quote (') with two single quotes ('') and then enclose the whole value within one pair of single quotes..
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question