Få Id tilbage

Fra SQL Server Books Online

IDENT_CURRENT is similar to the Microsoft® SQL Server™ 2000 identity functions SCOPE_IDENTITY and @@IDENTITY. All three functions return last-generated identity values. However, the scope and session on which 'last' is defined in each of these functions differ.

-IDENT_CURRENT returns the last identity value generated for a specific table in any session and any scope.

-@@IDENTITY returns the last identity value generated for any table in the current session, across all scopes.

-SCOPE_IDENTITY returns the last identity value generated for any table in the current session and the current scope.

Så du laver bare en SELECT på @@IDENTITY

Snowball

Ok, tak for det. Lidt smartere end: Select top 1 Id