• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 634
  • Last Modified:

SQL Server Management Studio 'Edit Top n Rows' - Change query

Hi..
Is it possible to specify a query when selecting 'Edit Top 200 Rows' in management studio?
When you right click on a table and select 'Edit Top 200 Rows'
I want to manual edit 100 records but need to change the order.
0
JElster
Asked:
JElster
1 Solution
 
Shaun KlineLead Software EngineerCommented:
You can change the query used by clicking the "Show SQL Pane" button, or under the Query Designer menu.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now