title: Insert dummy row in SQL select query
body: <p>I am working on SQL Server stored procedure. I have a table 'User' having fields (Id, Name, Email,Address).</p>
  
  <p>I have following query returning All Users </p>
  
  <pre><code>select * from [User]
  </code></pre>
  
  <p>It returns all users, but I just want to insert following dummy user to resulting record before returning it. </p>
  
  <p>User => Id = 0, Name = "All"</p>
  
  <p>This record will not be present with in the database but while returning result I want to insert this record as first record and then remaining users. I tried to find something like this but in vain.</p>