Get last inserted row (LAST RECORD)

Question

how i write stored procedure to get last record of the table It is ok if it is the primery key of the table

Jignesh Trivedi · Answer

hi when you want to get last record of the table? is it just after newly inserted record or any thing else? can please share your table structure?

Suthish Nair · Answer

Which thread you marked as Answer? Because am getting multiple mails. Please click only one thread as Answer.

Suthish Nair · Answer

http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/ CREATE TABLE [dbo].[Test] ( [ID] [int] IDENTITY(11) NOT NULL [Name] [varchar](50) NULL ) --select * from Test insert into Test (Name) VALUES ('A') select * from Test where ID = @@IDENTITY insert into Test (Name) VALUES ('B') select * from Test where ID = SCOPE_IDENTITY() insert into Test (Name) VALUES ('C') select * from Test where ID = IDENT_CURRENT('Test')

Sanjeeb Lenka · Answer

hi If your SQL Server table has a column of type INT IDENTITY (or BIGINT IDENTITY ) then you can get the latest inserted value using: SELECT SCOPE_IDENTITY()

Joxin Stanly · Answer

Hi Pasan please have a look @ below link.. http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/ h ope this helps