How to fetch the last inserted record in a particular table?

Answers were Sorted based on User's Feedback



How to fetch the last inserted record in a particular table?..

Answer / vimal katiyar

daer Archana your answer is nt complete so this s complete query fr last inserted record fetch from table

select * from <tablename> where id=(select max(id) from <table name>)

Is This Answer Correct ?    32 Yes 2 No

How to fetch the last inserted record in a particular table?..

Answer / raji22559

CommanObject.CommandText="Select @@Identity";

** Note: Over a given connection if any insert statement is
executed on a table with identity column , the back end
sql-server for the connection initializes a parameter by
name "@@Identity" with the value of Identity column for the
last inserted record.

Is This Answer Correct ?    18 Yes 8 No

How to fetch the last inserted record in a particular table?..

Answer / skumar

We can use the query like
SELECT TOP 1 ID FROM table ORDER BY ID DESC

Is This Answer Correct ?    11 Yes 2 No

How to fetch the last inserted record in a particular table?..

Answer / nitin kaushik

"select @@identity"
@@identity is used to get the current transaction value .

** Note: Over a given connection if any insert statement is
executed on a table with identity column , the back end
sql-server for the connection initializes a parameter by
name "@@Identity" with the value of Identity column for the
last inserted record.

Is This Answer Correct ?    9 Yes 1 No

How to fetch the last inserted record in a particular table?..

Answer / jk

By using scope_identity

Is This Answer Correct ?    9 Yes 2 No

How to fetch the last inserted record in a particular table?..

Answer / sudhakar sakthivel

select * from tableName where rowid = (select max(rowid)
from tableName);

in oracle

Is This Answer Correct ?    2 Yes 0 No

How to fetch the last inserted record in a particular table?..

Answer / neha

Through this statement, we can retrieve the same:

ds.Tables[0].Rows[ds.Tables[0].Rows.Count-1]

Is This Answer Correct ?    1 Yes 0 No

How to fetch the last inserted record in a particular table?..

Answer / muskaan

if(ds.Tables["tablename"].Rows.Count>0)
{
ds.Tables{"tablename"].Rows.Count-1;
}

Is This Answer Correct ?    3 Yes 4 No

How to fetch the last inserted record in a particular table?..

Answer / shashi

we get data from this Query

ds.table[0].rows.count-1

Is This Answer Correct ?    3 Yes 5 No

How to fetch the last inserted record in a particular table?..

Answer / archana

If a table have identity column then u can fetch the last
inserted record through following query:

"select max(ID) from test"

Is This Answer Correct ?    2 Yes 9 No

Post New Answer

More ADO.NET Interview Questions

What is a sqldataadapter?

0 Answers  


What is a column variable?

0 Answers  


What is defaultview in datatable?

0 Answers  


What is an ADO.Net?

0 Answers  


What is execute scalar in ado.net?

0 Answers  






What is disconnected data?

0 Answers  


What is the difference between ado.net and oledb?

0 Answers  


can we create synonymn in ms access,sql server,my sql if so explain me with example

0 Answers  


what is type dataset?

3 Answers  


What is difference between ado.net and asp net?

0 Answers  


What is the difference between statement and preparedstatement interface?

0 Answers  


What are the steps you will take to improve performance?

0 Answers  


Categories