Inserted ID in MS SQL Server

References:

  1. http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/
  2. http://www.dotblogs.com.tw/ajun/archive/2008/04/01/2504.aspx

Note: In Access it only support @@IDENTITY

Example: