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

How to bind the controls(best practice) comboboxes to the data in the dataset?

756

Which object holds only data and does not interact with data source?

709

What is Serialization in .NET? what are the types of Serialization?

746

What is ado rdo dao in visual basic?

869

What are the advantages using ado.net?

723

What is commandbuilder in ado.net?

704

What is the use of SqlCommand object?

856

What is serialization and de-serialization in .net?

686

What are the 3 major types of connection objects in ado.net?

739

Which is faster sqldataadapter and sqldatareader?

689

How does ado.net work?

657

Why do we need ado.net?

713

What is an ado connection?

698

How do you find the count of records in a dataset?

663

Which keyword is used to accept variable number of parameters?

867