title: Select Identity without 'into"
body: <p>Alright, I'm 99% sure it's possible... How do I select an identity column without using 'into' in SSMS 2008?</p>
  
  <p>For example,</p>
  
  <p>I know this doesn't work, but it's what I'm looking for...</p>
  
  <pre><code>Select  PK as Identity (int,1,1), A.*
  From    Table_1 A
  </code></pre>