Safest way to get last record ID from a table

user_174390 0
Viewed 155516

In SQL Server 2008 and higher what is the best/safest/most correct way

  1. to retrieve the ID (based on autoincrementing primary key) out of the database table?
  2. to retrieve the value of the last row of some other column (like, SELECT TOP 1 FROM Table ORDER BY DESC)?
sql-server-2008 sql-server sql
8 Answers

SELECT LAST(row_name) FROM table_name

user_114811310
Related