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

Question

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 1

You can escape the quotes with a backslash:

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

Answer 2

Use two single quotes to escape them in the sql statement. The double quotes should not be a problem:

SELECT 'How is my son''s school helping him learn?  "Not as good as Stack Overflow would!"' 

Print:

How is my son's school helping him learn? "Not as good as Stack Overflow would!"