6 Different Ways To Get The Current Identity Value in SQL

CREATE TABLE TestOne (id INT IDENTITY,SomeDate DATETIME)
CREATE TABLE TestTwo (id INT IDENTITY,TestOneID INT,SomeDate DATETIME)

  INSERT TestOne VALUES(GETDATE())
  INSERT TestOne VALUES(GETDATE())
  INSERT TestOne VALUES(GETDATE())
  INSERT TestOne VALUES(GETDATE())

SELECT @@IDENTITY

DBCC CHECKIDENT (TestOne, NORESEED)

SELECT MAX(id) FROM TestOne

SELECT TOP 1 id FROM TestOne ORDER BY id DESC

SELECT IDENT_CURRENT('TestOne')

SELECT SCOPE_IDENTITY()