title: SQL SERVER 2008 GET LAST INSERTED VALUES
body: <p>This is my table.</p>
  
  <pre><code>Ticket(id int auto_increment,name varchar(50));
  </code></pre>
  
  <p>after inserting into this table i want send id and name to mail..
  how can i get the last Inserted value.</p>
  
  <p>help to solve this...</p>