title: How Do I Escape Apostrophes in Field Valued in SQL Server?
body: <p>I asked a question a couple days ago about creating INSERTs by running a SELECT to move data to another server. That worked great until I ran into a table that has full on HTML and apostrophes in it. What's the best way to deal with this? Lucking there aren't too many rows so it is feasible as a last resort to 'copy and paste'. But, eventually I will need to do this and the table by that time will probably be way too big to copy and paste these HTML fields. </p>
  
  <p>This is what I have now:</p>
  
  <pre><code>select 'Insert into userwidget ([Type],[UserName],[Title],[Description],[Data],[HtmlOutput],[DisplayOrder],[RealTime],[SubDisplayOrder]) VALUES ('
      + ISNULL('N'''+Convert(varchar(8000),Type)+'''','NULL') + ','
      + ISNULL('N'''+Convert(varchar(8000),Username)+'''','NULL') + ','
      + ISNULL('N'''+Convert(varchar(8000),Title)+'''','NULL') + ','
      + ISNULL('N'''+Convert(varchar(8000),Description)+'''','NULL') + ','
      + ISNULL('N'''+Convert(varchar(8000),Data)+'''','NULL') + ','
      + ISNULL('N'''+Convert(varchar(8000),HTMLOutput)+'''','NULL') + ','
      + ISNULL('N'''+Convert(varchar(8000),DisplayOrder)+'''','NULL') + ','
      + ISNULL('N'''+Convert(varchar(8000),RealTime)+'''','NULL') + ','
      + ISNULL('N'''+Convert(varchar(8000),SubDisplayOrder)+'''','NULL') + ')' 
      from userwidget 
  </code></pre>
  
  <p>Which is works fine except those pesky apostrophes in the HTMLOutput field. Can I escape them by having the query double up on the apostrophes or is there a way of encoding the field result so it won't matter?</p>