last Inserted row id

Question

How to get the last inserted row in asp.net. .id is auto_increment

Munesh Sharma · Answer

select MAX(ID) from table

Rajeesh Menoth · Answer

Hi  vikram reddy ,   scope_identity()     The scope_identity() function returns the last identity created in the same session and the same scope.    Ref this example : http://www.aspsnippets.com/Articles/Return-Identity-Auto-Increment-Column-value-after-record-insert-in-SQL-Server-Database-using-ADONet-with-C-and-VBNet.aspx

Vignesh Mani · Answer

Hi if you use identity in your Id Columns you can use "Scope_Identity()" other wise you can use inline query you can find using max().

Rakesh · Answer

SELECT IDENT_CURRENT('tableName') or  select max(columnname) from tableName

Upendra Pratap Shahi · Answer

@@Identity(); SCOPE_IDENTITY();

Abrar Ahmad Ansari · Answer

use these function to get last inserted record.
@@Identity();
SCOPE_IDENTITY();