SCOPE_IDENTITY - TechNet - Microsoft

SQL Server 2000 ... However, SCOPE_IDENTITY returns values inserted only within the current scope; @@IDENTITY is ... and SCOPE_IDENTITY functions*/ INSERT TZ VALUES ('Rosalie') SELECT ...

technet.microsoft.com