Last Record In A Table 1

[Skittle]

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?

 

[ClaireHCM]

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

 

[ram1975]

Just press CTRL + End to reach the last record.

 

[Skittle]

Thanks.