How to handle-escape both single and double quotes in an SQL-Update statement

sql-server-2008 sql-update
MukeshAnAlsoRan picture MukeshAnAlsoRan · Jan 19, 2012 · Viewed 126.7k times · Source

I have this sample T-SQL query and trying this on SQL-Server-2008. 

DECLARE nvarchar(1000) @wstring = "I asked my son's teacher, "How is my son doing now?"" 

UPDATE tablename SET columnname = ' " & @wstring & " ' where ... blah ... blah

I know that the above query will throw error.

So how do I handle-escape both single and double quotes in an SQL-Update statement.

Answer

Russell Zahniser picture Russell Zahniser · Jan 19, 2012

You can escape the quotes with a backslash:

"I asked my son's teacher, \"How is my son doing now?\""

Related questions

How to write UPDATE SQL with Table alias in SQL Server 2008?

I have a very basic UPDATE SQL - UPDATE HOLD_TABLE Q SET Q.TITLE = 'TEST' WHERE Q.ID = 101; This query runs fine in Oracle, Derby, MySQL - but it fails in SQL server 2008 with following error: "Msg 102, Level 15, State 1, …

Read More
How to use update trigger to update another table?

I am new to triggers and want to create a trigger on an update of a column and update another table with that value. I have table1 with a year column and if the application updates that year column I …

Read More
How to update a varbinary field with a specific value?

Basically I am trying to give a user a certain password so I can test some functionality on a system, as I only have our admin account and I can't play with that I am just picking a random account …

Read More