How to select the last inserted record from the identity column
In Microsoft SQL Server, the identity column provides you with an unique id for each record, which is auto-incremented. To get the last added record from the database you will often want to select the latest added ID. Many have the false impression that they can select the biggest ID (number), and that will be the last added record. However, that’s not the case since the biggest ID is not always the latest. The solution is to use the following SQL query:
SELECT @@IDENTITY FROM MyTable;
This will return the ID of the last added record in the MyTable table.
Nathan Pakovskie is an esteemed senior developer and educator in the tech community, best known for his contributions to Geekpedia.com. With a passion for coding and a knack for simplifying complex tech concepts, Nathan has authored several popular tutorials on C# programming, ranging from basic operations to advanced coding techniques. His articles, often characterized by clarity and precision, serve as invaluable resources for both novice and experienced programmers. Beyond his technical expertise, Nathan is an advocate for continuous learning and enjoys exploring emerging technologies in AI and software development. When he’s not coding or writing, Nathan engages in mentoring upcoming developers, emphasizing the importance of both technical skills and creative problem-solving in the ever-evolving world of technology.
Specialties: C# Programming, Technical Writing, Software Development, AI Technologies, Educational Outreach
