I am using SQL Server 2000.
---
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.
---
I need the last identity generated for a specific table for the current
session. Looks like I can do one or the other, but not both. Or is there a
way to get it?
