title: How to handle-escape both single and double quotes in an SQL-Update statement
body: <p>I have this sample T-SQL query and trying this on SQL-Server-2008. </p>
  
  <pre><code>DECLARE nvarchar(1000) @wstring = "I asked my son's teacher, "How is my son doing now?"" 
  
  UPDATE tablename SET columnname = ' " &amp; @wstring &amp; " ' where ... blah ... blah
  </code></pre>
  
  <p>I know that the above query will throw error. </p>
  
  <p>So how do I  handle-escape both single and double quotes in an SQL-Update statement.</p>