title: get last inserted id in sql server 2008
body: <p>I want to get last inserted id of particular table. can any one tell me how i can get that?
  we have <code>mysql_insert_id()</code> in mysql. Do we have similar kind of function in sql server 2008? </p>