IDENT_CURRENT function

IDENT_CURRENT  This function returns the last identity value generated for a specified table or view. The last identity value generated can ...
Read More

How to compare identity values returned by IDENT_CURRENT, @@IDENTITY and SCOPE_IDENTITY?

Comparing identity values returned by IDENT_CURRENT, @@IDENTITY and SCOPE_IDENTITY The following example shows the different identity values...
Read More