@@IDENTITY VS SCOPE_IDENTITY Function 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