Safest way to get last record ID from a table

by 
SELECT IDENT_CURRENT('Table')

You can use one of these examples:

SELECT * FROM Table 
WHERE ID = (
    SELECT IDENT_CURRENT('Table'))

SELECT * FROM Table
WHERE ID = (
    SELECT MAX(ID) FROM Table)

SELECT TOP 1 * FROM Table
ORDER BY ID DESC

But the first one will be more efficient because no index scan is needed (if you have index on Id column).

The second one solution is equivalent to the third (both of them need to scan table to get max id).

More Related Contents:

  1. How to delete 0 values but not blanks from a column in SQL Server 2008 programming?
  2. Unpivot with column name
  3. How can I delete using INNER JOIN with SQL Server?
  4. What this query does to create comma delimited list SQL Server?
  5. SQL Server – Return value after INSERT
  6. Convert varchar into datetime in SQL Server
  7. sql query to return differences between two tables
  8. Check if a row exists, otherwise insert
  9. How to select the last record of a table in SQL?
  10. How to create table using select query in SQL Server?
  11. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  12. How to write UPDATE SQL with Table alias in SQL Server 2008?
  13. SQL Server 2008- Get table constraints
  14. SQL SERVER: Get total days between two dates
  15. Restrict an SQL Server connection to a specific IP address
  16. Execute Dynamic Query with go in sql
  17. TransactSQL to run another TransactSQL script
  18. How can I get a list of element names from an XML value in SQL Server
  19. Why are logical reads for windowed aggregate functions so high?
  20. Store multiple bit values in a single table column
  21. How to rename something in SQL Server that has square brackets in the name?
  22. Comma Separated values with SQL Query
  23. how to separate string into different columns?
  24. How do I change db schema to dbo
  25. Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
  26. SQL Server: +(unary) operator on non-numeric Strings
  27. Use one CTE many times
  28. How to Select Every Row Where Column Value is NOT Distinct
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment