Get the last inserted row ID (with SQL statement) [duplicate]

by

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

INSERT INTO dbo.YourTable(columns....)
   VALUES(..........)

SELECT SCOPE_IDENTITY()

This works as long as you haven’t inserted another row – it just returns the last IDENTITY value handed out in this scope here.

There are at least two more options – @@IDENTITY and IDENT_CURRENT – read more about how they works and in what way they’re different (and might give you unexpected results) in this excellent blog post by Pinal Dave here.

More Related Contents:

  1. SQL Server bulk insert for large data set
  2. T-SQL split string
  3. Solutions for INSERT OR UPDATE on SQL Server
  4. Exclude a column using SELECT * [except columnA] FROM tableA?
  5. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  6. Conditional WHERE clause in SQL Server
  7. SQL NOT IN not working
  8. How to Join to first row
  9. Concatenate row values T-SQL
  10. GROUP BY to combine/concat a column [duplicate]
  11. How to return multiple values in one column (T-SQL)?
  12. Difference between “read commited” and “repeatable read”
  13. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  14. Parse comma-separated string to make IN List of strings in the Where clause
  15. conditional unique constraint
  16. How do I execute a stored procedure once for each row returned by query?
  17. T-SQL: Selecting Column Based on MAX(Other Column)
  18. How to group by month from Date field using sql
  19. Why is my t-sql left join not working?
  20. PIVOT query on Distinct records
  21. Grouped string aggregation / LISTAGG for SQL Server
  22. Curly braces in T-SQL
  23. Performance of SQL Server 2005 Query
  24. OPENXML with xmlns:dt
  25. Custom Date/Time formatting in SQL Server
  26. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  27. Find min and max for subsets of consecutive rows – gaps and islands
  28. How to set bool value in SQL
  29. Finding node order in XML document in SQL Server
  30. SQL Server – Query Short-Circuiting?

Leave a Comment