How do I get the last inserted row ID in SQL?

Question

Use @@IDENTITY to Return the Last-Inserted Identity Value in SQL Server. In SQL Server, you can use the T-SQL @@IDENTITY system function to return the last-inserted identity value in the current session. Note that it returns the last identity value generated in any table in the current session. 16 янв. 2020 г.

How do I get the inserted row id in SQL Server?

4 ways to get identity IDs of inserted rows in SQL Server1INSERT INTO TableA (...) VALUES (...) SET @LASTID = @@IDENTITY.2INSERT INTO TableA (...) VALUES (...) SET @LASTID = SCOPE_IDENTITY()3SET @LASTID = IDENT_CURRENT('dbo.TableA')4DECLARE @NewIds TABLE(ID INT, ...) INSERT INTO TableA (...) OUTPUT Inserted.ID, ...4 ways to get identity IDs of inserted rows in SQL Server

How can get last identity value in SQL Server?

@@IDENTITY returns the last identity value generated for any table in the current session, across all scopes. SCOPE_IDENTITY returns the last identity value generated for any table in the current session and the current scope.

Expert · Answer

4 ways to get identity IDs of inserted rows in SQL Server1INSERT INTO TableA (...) VALUES (...) SET @LASTID = @@IDENTITY.2INSERT INTO TableA (...) VALUES (...) SET @LASTID = SCOPE_IDENTITY()3SET @LASTID = IDENT_CURRENT('dbo.TableA')4DECLARE @NewIds TABLE(ID INT, ...) INSERT INTO TableA (...) OUTPUT Inserted.ID, ...4 ways to get identity IDs of inserted rows in SQL Server

Expert · Answer

@@IDENTITY returns the last identity value generated for any table in the current session, across all scopes. SCOPE_IDENTITY returns the last identity value generated for any table in the current session and the current scope.

How do I get the last inserted row ID in SQL?

How do I get the inserted row id in SQL Server?

How can get last identity value in SQL Server?

Related Questions