Finding last inserted row id

if record id is identity field then from @@Identity variable you ll get last id

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere
http://fieredotnet.wordpress.com/

Parimi.chowdary, if this helps please login to Mark As Answer. | Alert Moderator

Sometime @@identity may not give you the correct result , in case some insert is going on a different table
You can use SCOPE_IDENTITY() function just after the insert statement go get the new identity value.

Parimi.chowdary, if this helps please login to Mark As Answer. | Alert Moderator

Also you can use

Output.Inserted

Best Regards,
Niladri Biswas

Parimi.chowdary, if this helps please login to Mark As Answer. | Alert Moderator

Code:SELECT TOP 1 Id FROM Table1 ORDER BY Id DESC
solution2-

Code:
SELECT MAX(Id) FROM Table1


Hope This will Hep

Let me know any questions..

Regards
Sriram.R

sriram

Parimi.chowdary, if this helps please login to Mark As Answer. | Alert Moderator

CREATE TABLE dbo.tracking0
(
userID INT IDENTITY(1,1)
PRIMARY KEY CLUSTERED,
username VARCHAR(32)
)
GO

Then, to get the "last" row:

SELECT userID, username
FROM dbo.tracking0
WHERE userID =
(
SELECT MAX(userid)
FROM dbo.tracking0
)

sriram

Parimi.chowdary, if this helps please login to Mark As Answer. | Alert Moderator