title: How can I add a "custom" row to the top of a select result set?
body: <p>I can select and pull out a list of records by using a select statement like so with t-sql:</p>
  
  <pre><code>select * from [dbo].[testTable];
  </code></pre>
  
  <p>But how can I add in a "custom" row to the top of the result set?</p>
  
  <p>For example, if the result set was:</p>
  
  <pre><code>John    john@email.com
  Max     max@domain.com
  </code></pre>
  
  <p>I want to add a row, which is not from the table, to the result set so that it looks like so:</p>
  
  <pre><code>Name    Email
  John    john@email.com
  Max     max@domain.com
  </code></pre>
  
  <p>The reason why I want to do this is because I'm going to export this into a csv file through sqlcmd and I want to add in those "custom row" as headers.</p>