sql get inserted primary key

Rasel Ahmed answered on June 20, 2022 Popularity 8/10 Helpfulness 9/10

answer sql get inserted primary key

sql get inserted primary key

Comment

CREATE TABLE #a(identity_column INT IDENTITY(1,1), x CHAR(1));
INSERT #a(x) VALUES('a');

SELECT SCOPE_IDENTITY();

-- 4 ways to get identity IDs of inserted rows in SQL Server
INSERT INTO TableA (...) VALUES (...)
SELECT @@IDENTITY

INSERT INTO TableA (...) VALUES (...)
SELECT SCOPE_IDENTITY()

SELECT IDENT_CURRENT('dbo.TableA')

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

Popularity 8/10 Helpfulness 9/10 Language sql

Source: www.munisso.com

Tags: get primary-key record sql sql-server

Link to this answer
Share Copy Link

Contributed on Jun 20 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

sql get inserted primary key

Contents

More Related Answers

sql get inserted primary key

Grepper

Documentation

Social

Legal

Contact

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