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 ado full form?
What are all the different authentication techniques used to connect to MS SQL Server?
Why is stored procedure used in ado.net?
What are two types of transaction supported by ado.net?
Explain the architecture of ado.net?
What is ole db and odbc?
What is an orm, and why would you use one instead of plain old ado.net?
What is sequence of code in retrieving data from database ?
3 Answers Accenture, BirlaSoft,
What are the namespaces used in ado.net for data access?
What are the different layers of ado.net?
Explain acid properties?
What is dataset and datatable in ado.net?