Last identity value generated for any table in the current session, for the current scope : SCOPE_IDENTITY « Sequence Indentity « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Sequence Indentity
  3. SCOPE_IDENTITY
5> SELECT SCOPE_IDENTITY()
6>
15.7.SCOPE_IDENTITY
15.7.1.Last identity value generated for any table in the current session, for the current scope
15.7.2.Using the SCOPE_IDENTITY() Function
15.7.3.SELECT SCOPE_IDENTITY()