GitHub

scope-identity-transact-sql.md

Returns the last identity value inserted into an identity column in the same scope. A scope is a module: a stored procedure, trigger, function, or batch. Therefore ...
GitHub

scope-identity-transact-sql.md

[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)] Returns the last identity value inserted ...
findnerd.com

SQL Server : Difference between @@IDENTITY, SCOPE_IDENTITY () and IDENT_CURRENT

The keyword "@@IDENTITY" in current session is capable of returning newly inserted or last record id of any given table but it’s functionality is not limited to current scope. If any trigger or ...