How to get the last identity value generated for any table in SQL ?

The IDENT_CURRENT function returns the last IDENTITY value generated for any specific table or view on an identity column in any session and any scope.… Read More »IDENT_CURRENT Function