Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mamatha
Posting Yak Master
102 Posts |
 Posted - 2005-01-06 : 02:47:27
|
| Hiwe have an application in ASP,and my database is in SQL Server2000.i want to display the table records in reverse order means which was most recently entered record is displayed as a top row in ASP page.But from another ASP page we want to delete the old record and insert new record in that place.So the record alignment was changed and inserted in another place not in a particular order.Here we have to problems:how can we display most recent records on top row and oldest one bottom of ASP page.How can we delete only old record and inserted as a last row in table.Please give us the solution.Thanks in advanceMamatha |
|
|
sudheesh_k_s
Starting Member
10 Posts |
Posted - 2005-01-06 : 06:39:31
|
| Have you got datetime fields inthe table. If so check the insertion datetime and display. Or maybe if you have primary key which keeps on incrementing include that key in the select list and order the select ( order by Primarykey desc) |
 |
|
|
|
|
|
How to navigate through recordsets in SQL server