SQL Server - Query to Get Last Inserted Record Id

Introduction:

In this article I will explain how to write query to get last inserted record id in sql server or last modified record id value in SQL Server.

Description:

In previous post I explained how to set identity property or auto increment column in data table and many articles relating to SQL Server. Now I will explain how to write a query to get last inserted record id value or last modifies record id in SQL Server. Generally if we create data table we will set identity column or auto increment column in table to increase column id value automatically whenever new record inserted in SQL Server. In one situation I got requirement like to get last inserted record Id from data table in SQL Server.

Before write query first design one table and give name as EmployeeDetails in your database as shown below

EmployeeDetails Table

Column Name	Data Type	Allow Nulls
EmpId	Int (set Identity=true)	No
EmpName	varchar(50)	Yes
Role	Varchar(50)	Yes

To insert new record in above table we need to write query like this

INSERT INTO EmployeeDetails(EmpName,Role) VALUES('SureshDasari','Team Lead')

Now if we want to get last inserted record we have multiple options check below queries

The table which is having Identity Property from that table we can get the last inserted record id will be like this

SELECT @@IDENTITY SELECT SCOPE_IDENTITY() SELECT IDENT_CURRENT('TableName')

Another way we can get it in

SELECT MAX(EmpId) FROM EmployeeDetails

Other way

SELECT TOP 1 EmpId FROM EmployeeDetails ORDER BY EmpId DESC

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email