How to fetch the last inserted record in a particular table?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Answer / sudhakar sakthivel
select * from tableName where rowid = (select max(rowid)
from tableName);
in oracle
Is This Answer Correct ? | 2 Yes | 0 No |
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 |
Answer / muskaan
if(ds.Tables["tablename"].Rows.Count>0)
{
ds.Tables{"tablename"].Rows.Count-1;
}
Is This Answer Correct ? | 3 Yes | 4 No |
Answer / shashi
we get data from this Query
ds.table[0].rows.count-1
Is This Answer Correct ? | 3 Yes | 5 No |
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 |
What is a sqldataadapter?
What is a column variable?
What is defaultview in datatable?
What is an ADO.Net?
What is execute scalar in ado.net?
What is disconnected data?
What is the difference between ado.net and oledb?
can we create synonymn in ms access,sql server,my sql if so explain me with example
what is type dataset?
What is difference between ado.net and asp net?
What is the difference between statement and preparedstatement interface?
What are the steps you will take to improve performance?