title: How do I escape a single quote in SQL Server?
body: <p>I am trying to <code>insert</code> some text data into a table in SQL Server 9.</p>
  <p>The text includes a single quote <code>'</code>.</p>
  <p>How do I escape that?</p>
  <p>I tried using two single quotes, but it threw me some errors.</p>
  <p>eg. <code>insert into my_table values('hi, my name''s tim.');</code></p>