title: Get the last inserted row ID (with SQL statement)
body: <p>I want to get the new created ID when you insert a new record in table.</p>
  
  <p>I read this: <a href="http://msdn.microsoft.com/en-us/library/ms177564.aspx">http://msdn.microsoft.com/en-us/library/ms177564.aspx</a> but it needs to create temporary table.</p>
  
  <p>I want to return the ID after executing INSERT statement (assuming executing just one INSERT).</p>
  
  <p>Example: </p>
  
  <pre><code>1     Joe      Joe
  2     Michael  Mike
  3     Zoe      Zoe
  </code></pre>
  
  <p>When executing an INSERT statement, I want to return the created ID, means 4.</p>
  
  <p>Can tell me how to do that using SQL statement or it is not possible ?</p>