title: Incorrect syntax near 'month' with dynamic number
body: <p>While running this query</p>
  
  <pre><code>update p_leave_allocation_14122015 
  set 'month' + @actualMonth  = @actualleavedays
  where year = @actualYear  
    and emp_card_no = @emp_card_no 
  </code></pre>
  
  <p>I get an error:</p>
  
  <blockquote>
    <p>Incorrect syntax near 'month'.</p>
  </blockquote>
  
  <p>The table <code>p_leave_allocation_14122015</code> has columns like <code>month1</code>, <code>month2</code>, <code>month3</code>,<strong>.....</strong></p>
  
  <p>In my update query what I want is <code>month</code> will be hardcoded and the no of month will be dynamic based on some conditions which I have written.</p>
  
  <p>But when I tried with the above query I got the mentioned error.</p>
  
  <p>I am using SQL Server 2005.</p>
  
  <p>Kindly suggest</p>