title: Set the value of a column in a SELECT?
body: <p>In MySQL I could execute the following:</p>
  
  <pre><code>SELECT "spam" AS "foo", "eggs" AS "bar" LIMIT 1;
  </code></pre>
  
  <p>...which would return 1 row with 2 columns ("foo" and "bar) and 2 values ("spam" and "eggs").</p>
  
  <p>Is it possible to do this with TSQL in SQL Server?</p>