Post reply

How to Sort Table

  • December 4, 2007 at 8:05 am

    #177102

    When I open a table in SQL2005, is there a way to sort the table on one of the columns? I know I can run a query to sort it, but I want to be able to sort the table and modify information at one time.

    Thanks for your help!

  • December 4, 2007 at 8:33 am

    #756976

    The data is sorted in clustered index order, but this isn't the idea of SQL Server.

    Are you thinking to edit data in SSMS? If so, you could move the clustered index to that field, do the editing, then move it back to where it was.

  • December 4, 2007 at 8:45 am

    #756986

    You can do this using Access.

    Create ODBC linked table and queries.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply