title: Renaming a Column Name is SQL as for example [Incident#]
body: <p>I am trying to automate my workflow in SQL Server where I get an Excel file with a column name <code>[Incident#]</code>. I want to rename this column using a query and I can't seem to select this column by its name, here is my query:</p>
  
  <pre><code>exec sp_rename 'dbo.testproc.[Incident#]', 'INCIDENT', 'COLUMN';
  </code></pre>
  
  <p>I will really appreciate if any of you could help me to fix this issue.</p>
  
  <p>Thanks</p>