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

What is difference between Dataview and Datatable?

1076

What is data access pattern?

950

What are advantages of microsoft-provided data provider classes in ado.net?

1008

Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

1147

What is sqldatareader in ado.net?

922

Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

1002

What is difference between sqldatareader and sqldataadapter?

931

What are the namespaces used in ado.net for data access?

987

What is sql connection in ado.net?

951

Which database is the ado.net?

980

Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

1021

How to check if a datareader is closed or opened? IsClosed()

1031

What is Data Provider?

1056

Explain how do you connect to sql server database without using sqlclient?

1012

What are the usages of the command object in ado.net?

1024