title: Dynamic SQL statement (unicode encoding needed?)
body: <p>I have the following dynamic SQL code with 4 columns inserted as parameters as well as the table name.  </p>
  
  <pre><code>set @SQL = 'select EVENTID, RATE,' + @LossColumn + ',' + @ExpColumn + ',' + @StdDevIndep + ',' + @StdDevCorr + ', '''','''', '''','''' 
  from Catastrophe.dbo.' + @CatTableName 
  insert into AnalyticsV2.dbo.ResultCSVCat
  execute sp_executesql @SQL
  </code></pre>
  
  <p>I'm not sure if this is correct or whether it needs unicode encoding because of the parameters (N before the 'select statement)?  It works fine if I specify all the columns and table name because then there are no parameters.  I'm not quite sure how to change it around if it does need unicode because I haven't worked with that very much in Microsoft SQL.</p>
  
  <p>Any help will be appreciated!</p>