title: SQL Server: how can I promote headers?
body: <p>I have a table in SQL Server 2016 which looks similar to this (all columns are <code>nvarchar</code> and there are over 15 columns, also I have an <code>IDENTITY</code> column not shown):</p>
  
  <p><strong>Table1</strong>:</p>
  
  <pre><code>  [Col1]                  [Col2]                  [Col3]                  [Col4]
    ----------------------------------------------------------------------------------              
    12-05-2016 10:29:48     12-06-2016 03:29:48     NULL                    132.43
    StartTime               TaskNumber              EndTime                 TotalValue
    12-01-2017 11:15:00     48                      12-01-2017 12:32:00     24.1
  </code></pre>
  
  <p>As you can see, each column contains text which is actually supposed to be the column's header. How can I set the columns name equal to this value?</p>
  
  <p>Note, the columns are not always in the same order. The data comes from a source that can contain the columns in any random order.</p>