title: can SQL insert using select return multiple identities?
body: <p>I am insertnig into a table using a selection</p>
  
  <pre><code>INSERT california_authors (au_id, au_lname, au_fname)
  SELECT au_id, au_lname, au_fname
  FROM authors
  WHERE State = 'CA'
  </code></pre>
  
  <p>say i have an identity column in <code>california_authors</code>. Can i get all the ids inserted by the above particular insertion just like i can get @@IDENTITY for last <code>single insertion</code> ?</p>
  
  <p>I can't use select command for <code>california_authors</code> as there may exists previously inserted records with filter <code>State = 'CA'</code></p>