sql-serverquery-analyzer

Is it possible to modify the default SQL in query analyzer for 'edit top 200 rows'?

What if I want to edit the bottom 200 rows, or a custom query, is this possible?

Solution

  • You should be able to do the following:

    1. Load the query window with the edit 200 rows
    2. From the Query Designer Menu > Pane > SQL or use the SQL button from the Query Designer toolbar
    3. Edit the query to the number of rows that you want or order by ID, etc
    4. Execute the new query and the window will be refreshed.