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 |
|
lols
Posting Yak Master
174 Posts |
 Posted - 2009-09-29 : 05:02:17
|
| When I right click on the table, I get the option to Edit TOP 200 rows. I went to option and changed this to TOP 1 row. Now when i open that row, that is not the latest but the last row of my database.How can I Edit the latest row inserted in my table? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-10-01 : 10:17:28
|
| by using an "ORDER BY RECORDID DESC" clause in your SQL??ordering of data (of which the terms "first" and "last" is covered) is only guaranted by use of the ORDER BY clause. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-01 : 15:09:34
|
quote:
Originally posted by lols
When I right click on the table, I get the option to Edit TOP 200 rows. I went to option and changed this to TOP 1 row. Now when i open that row, that is not the latest but the last row of my database.How can I Edit the latest row inserted in my table?
why are you trying to edit through grid?you can never guarantee that records will be retrieved in order of insertion in table unless you specify order explicitly with help of order by |
|
|
|
|
|
|
Open Latest Row in SQL Server Management Studio