title: How to add a string with (') in insert in to statement in SQL
body: <p>I am trying to manually add a item into my table in SQL Server by using <code>insert into</code> statements, but I get an error.</p>
  
  <p>Normally a string is added using a single apostrophe in front and back of the string in SQL Server, but I am adding a value which has an apostrophe in between (like <code>can't</code>), how to add this in the T-SQL <code>insert into</code> statement?</p>
  
  <p>I did try 3 different methods to insert but still failed</p>
  
  <pre><code>insert into orders (6, 'microsoft surface pro', 'IDHGHRTUJ'''123456', 1, 8)
  insert into orders (6, 'microsoft surface pro', 'IDHGHRTUJ'123456', 1, 8)
  insert into orders (6, 'microsoft surface pro', "IDHGHRTUJ'123456", 1, 8)
  </code></pre>
  
  <p>I need output in this of the string with the apostrophe in iot</p>