Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Last Record In A Table 1

Status
Not open for further replies.

Skittle

ISP
Joined
Sep 10, 2002
Messages
1,528
Location
US
By right clicking on an SQL table and selecting 'open' followed by 'return all rows' I get a grid of all records in the file. Is there a way to go to the end of the grid of rows in one key stroke combination so I can see the last page of records?
 
Do the select statement in Query Analyzer

If you have a column which record the sequence of the rows (either identity,or timestamp,datetime)

select top 1 * from MyTable order by col_name desc
 
Just press CTRL + End to reach the last record.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top