title: Characters that must be escaped in T-SQL
body: <p>I was looking for a list of special characters that must be escaped in ms sql server but could not find one and most of answers I saw for the similar questions advised to use Parameterised queries.. which I am already doing but the framework I am using does not does any escaping for me. </p>
  
  <p>Thus I thought I will give a bunch of those a try and see which one fails.... and I tried a simple query </p>
  
  <pre><code>select * from x where value = '&lt;characters&gt;'
  </code></pre>
  
  <p>in such query I tried almost all the characters I could find on my keyboard and all of them seem to work... besides the Singe Quote.. that one fails.</p>
  
  <p>Thus I want to know the list of characters that are invalid and must be escaped in ms sql server - tsql and do not want to take the risk of just escaping the single quote and leave the rest that could cause trouble </p>
  
  <p>Appreciate your help</p>