IDENT_CURRENT (Transact-SQL) - MSDN - Microsoft

--Do the following in Session 1 INSERT t6 DEFAULT VALUES; SELECT @@ IDENTITY; /*Returns the value 100.

msdn.microsoft.com