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 are the uses of Stored Procedure?

1114

What is dataset and datatable in ado.net?

1047

What is executequery?

994

What is the meaning of executenonquery?

1144

What are the features of ado.net?

1120

What is difference between entity framework and ado.net?

987

What does datareader object do?

1064

What is the difference between ado.net and entity framework?

1099

What is difference between dataset and datatable?

1274

What are the major difference between classic ADO and ADO.NET?

1058

How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1086

What are the parameters that control most of connection pooling behaviors?

1052

Explain the dataadapter class in ado.net?

1268

What is sqldatasource?

980

What is the difference between Datareader and Dataset?

1134