SCOPE_IDENTITY (Transact-SQL) - MSDN - Microsoft

Returns the last identity value inserted into an identity column in the same scope. A scope is a ... ContactType ([Name]) VALUES ('Assistant to the Manager'); GO SELECT SCOPE_IDENTITY() AS ...

msdn.microsoft.com