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.
