If a table have identity column then u can fetch the last inserted record

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

Question Posted / archana

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Which is faster entity framework or ado.net?

879

How to enable and disable connection pooling?

995

Explain the different row versions available in table?

975

What is the difference between Command and CommandBuilder object?

1111

What is difference between ado.net and asp net?

970

What is the difference between linq and ado.net?

941

What is untyped dataset?

1035

Why do we use sqldataadapter?

907

What does adodb stand for?

973

What are the objects of ado.net?

1012

What is ole2 format?

848

What is the difference between a datareader and a dataset?

938

Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

1014

How to connect and retrieve data from database using dataset

983

What is DataReader Object?

984