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

Question

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

score 3 · Accepted Answer · answered Jan 08 '13 at 20:56

You should be able to do the following:

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

score 2 · Answer 2 · edited Aug 25 '16 at 15:46

2

When you click on "edit Top 200 rows", there is a button on the top right corner that says "SQL", when you click on that, you can write your custom query.

If you want the default value for the edit TOP n rows, you can go to "Tools->Options->SQL Server Object Explorer" and edit the 200 there.

edited Aug 25 '16 at 15:46

Jeff Puckett

37,464
17
118
167

answered Jan 08 '13 at 20:57

Lamak

69,480
12
108
116

score 1 · Answer 3 · answered Jan 08 '13 at 20:56

1

I'm not sure about Query Analyzer, but in Management Studio you can right click and select Pane > SQL to view/edit the SQL query used

answered Jan 08 '13 at 20:56

msmucker0527

5,164
2
22
36

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

3 Answers3