Loading

getting the current value of an auto-incrementing ID

flbreen

I have a table with an with a key column with the name id declared as an auto-number so that it automatically increments when I insert a record to the table. What Select statement can I run to determine what the current (last) value of id is?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

tsuman_in22y ago
hey, it's a typo, but important. You meant the @@IDENTITY
kovan22y ago
if you are using SQL Server you can return the autonumber when you first insert using @identity (look this one up) this will save you a extra call i posted above.
kovan22y ago
select max(fieldName) as lastInsertedVal FROM tableName