May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

Interview Question of the Week #030 – Retrieve Last Inserted Identity of Record

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
SQL Identity
Question: What are the different ways of retrieving the identity of last inserted record? Which method do you prefer? Answer: There are many different ways to do that. Here are three different ways to retrieve the identity of the last inserted record. I personally use SCOPE_IDENTITY () to return the identity…
Read More

SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype – Part 2

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Identity
Seven years ago, I wrote a blog post about – Query to Find Seed Values, Increment Values and Current Identity Column value of the table. It is quite a popular blog post and lots of people like it as it gives immediate details about Identity Values. SQL expert Mark Hickin…
Read More