getting the current value of an auto-incrementing ID

Question

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?

tsuman_in · Answer

hey it's a typo but important. You meant the @@IDENTITY

kovan · Answer

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.

kovan · Answer

select max(fieldName) as lastInsertedVal FROM tableName