title: Get the ID of last inserted records
body: <p>I'm inserting multiple records to a table using the below query:</p>
  
  <pre><code>INSERT INTO Table1(FirstName, LastName, EmailAddress)
      SELECT t2.FirstName, t2.LastName, t2.EmailAddress
      FROM Table2 t2
  </code></pre>
  
  <p>Since the query is inserting multiple records, I can't use <strong>SCOPE_IDENTITY</strong> to retrieve PK. Is there any method to get the ID's of last inserted records?</p>