all groups > sql server programming > june 2004 >
You're in the

sql server programming

group:

Sorting Table and moving to last row in Enterprise Manager


Re: Sorting Table and moving to last row in Enterprise Manager Rohtash Kapoor
6/5/2004 8:47:34 PM
sql server programming: #1. To sort a table by order of a specific column in the SQL Server
Enterprise Manager, click on "Show/Hide SQL Pane" in the Toolbar on the top.
There you can add ORDER BY clause and then click "Run" button on the
toolbar.

#2. To quickly move to the last row within a table you can press CTRL+End
key.

---
Rohtash Kapoor
http://www.sqlmantra.com



[quoted text, click to view]

Sorting Table and moving to last row in Enterprise Manager Oscar
6/5/2004 11:21:39 PM
Is there a way to sort a table by order of a specific column in the SQL
Server Enterprise Manager (Just like MS Access does by clicking at the field
name) ?

How can I move quickly to the last row within a table with many rows in the
SQL Server Enterprise Manager? I noticed that the scroll button don't work
properly. After that I set the scroll block to the lowest level, it jumps
back to a higher position.

Oscar

Re: Sorting Table and moving to last row in Enterprise Manager Oscar
6/6/2004 7:11:53 PM
Thanks for your help Rohtash.

Actually I'd thought that the Sort Ascending and Sort Descending buttons
would do this job, however they are always disabled to use. Any suggestion
how to get them enabled ?
Oscar


"Rohtash Kapoor" <rohtash_nospam@sqlmantra.com> schreef in bericht
news:Or7gDk3SEHA.3580@TK2MSFTNGP09.phx.gbl...
[quoted text, click to view]

Re: Sorting Table and moving to last row in Enterprise Manager Rohtash Kapoor
6/6/2004 9:27:17 PM
Sort Ascending and Sort Descending buttons will become enable when you click
"Show/Hide Diagram Pane" and then click on any column of the table. Then
you can specify the ascending or descending order.

---
Rohtash Kapoor
http://www.sqlmantra.com


[quoted text, click to view]

AddThis Social Bookmark Button