Last entered row SQL Server

 These are the various choices you have to get the latest identity entered into a table in SQL server

SELECT @@IDENTITY

SELECT SCOPE_IDENTITY()

SELECT IDENT_CURRENT(‘tablename’)


The most often I personally use is SELECT SCOPE_IDENTITY()

I will defer to an excellent article from Pinal Dave for an explanation on each of these

http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/