IDENT_CURRENT (Transact-SQL) - MSDN - Microsoft

SELECT SCOPE_IDENTITY(); /* Returns the value 1. This was inserted by the INSERT statement two statements before ...

msdn.microsoft.com