Breaking News: Grepper is joining You.com. Read the official announcement!

How to get last inserted primary key in SQL Server

Add Answer

Rasel Ahmed answered on June 16, 2020 Popularity 8/10 Helpfulness 5/10

answer How to get last inserted primary key in SQL Server

related sql get last primary key inserted

related get last inserted primary key

How to get last inserted primary key in SQL Server

Comment

-- 4 ways to get identity IDs of inserted rows in SQL Server

INSERT INTO TableA (...) VALUES (...)
SET @LASTID = @@IDENTITY

INSERT INTO TableA (...) VALUES (...)
SET @LASTID = SCOPE_IDENTITY()

SET @LASTID = IDENT_CURRENT('dbo.TableA')

DECLARE @NewIds TABLE(ID INT, ...)

INSERT INTO TableA (...)
OUTPUT Inserted.ID, ... INTO @NewIds
SELECT ...

Popularity 8/10 Helpfulness 5/10 Language sql

Source: www.munisso.com

Tags: get primary-key sql sql-server

Link to this answer
Share Copy Link

Contributed on Jun 20 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

Closely Related Answers

sql get last primary key inserted

Comment

-- @@IDENTITY - Returns the last identity created in the same session
-- SCOPE_IDENTITY() - Returns the last identity created in the same session and the same scope
-- IDENT_CURRENT() - Returns the last identity created for a specific table or view in any session
-- OUTPUT Inserted.[ColumnName] INTO [Table] - Returns a list of created identities (used for multi inserts)

/*Examples Start*/
IF OBJECT_ID('tempdb..#tmpT') IS NOT NULL
	DROP TABLE #tmpT

IF OBJECT_ID('TableA') IS NOT NULL
	DROP TABLE TableA

CREATE TABLE TableA (
	ID NUMERIC(18,0) IDENTITY(1,1),
	Name VARCHAR(255),
	PRIMARY KEY (ID)
)

INSERT INTO TableA (Name) VALUES ('Jane')
SELECT @@IDENTITY AS [ID]

INSERT INTO TableA (Name) VALUES ('John')
SELECT SCOPE_IDENTITY() AS [ID]

INSERT INTO TableA (Name) VALUES ('Smith')
SELECT IDENT_CURRENT('dbo.TableA') AS [ID]

DECLARE @NewIds TABLE(ID NUMERIC(18,0))
INSERT INTO TableA (Name)
OUTPUT Inserted.ID INTO @NewIds
VALUES ('Joe'), ('Bloggs')
SELECT * FROM @NewIds

CREATE TABLE #tmpT (ID NUMERIC(18,0))
INSERT INTO TableA (Name)
OUTPUT Inserted.ID INTO #tmpT
VALUES ('Joe'), ('Bloggs')
SELECT * FROM #tmpT
/*Examples End*/

Popularity 9/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: get

Link to this answer
Share Copy Link

Contributed on Oct 05 2022

Mackie7

0 Answers Avg Quality 2/10

get last inserted primary key

Comment

INSERT INTO dbo.Table(columns)
OUTPUT INSERTED.p_key, INSERTED.someothercolumnhere .......
VALUES(...)

Popularity 6/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: get primary-key sql

Link to this answer
Share Copy Link

Contributed on Jun 16 2020

Sal-versij

0 Answers Avg Quality 2/10

How to get last inserted primary key in SQL Server

Contents

More Related Answers

How to get last inserted primary key in SQL Server

Closely Related Answers

sql get last primary key inserted

get last inserted primary key

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.