SQL Server 101 – Get the identity of inserted row

If you are looking at a way to find the identity of the inserted row in SQL Server , you can use the SCOPE_IDENTITY().

How to get the identity of the inserted row in SQL Server ?

SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY are similar functions because they return values that are inserted into identity columns.

The difference is that SCOPE_IDENTITY() returns the last identity value generated for any table in the current scope.

SELECT SCOPE_IDENTITY()
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.