title: SQL Server - Return value after INSERT
body: <p>I'm trying to get a the key-value back after an INSERT-statement. 
  Example: 
  I've got a table with the attributes name and id. id is a generated value.</p>
  
  <pre><code>    INSERT INTO table (name) VALUES('bob');
  </code></pre>
  
  <p>Now I want to get the id back in the same step. How is this done?</p>
  
  <p>We're using Microsoft SQL Server 2008.</p>