Dear, I would like to know if I can edit the option that appears when I right click on a table in a database in sql server 2008 "Edit the first 'x' rows".
What I would like to modify is to show me the rows ordered by one of the fields that I choose from highest to lowest.
Is it possible?
When you edit a table, a Show Criteria icon appears on the toolbar.
You can sort by applying the criteria or filter you need. With the other command Show SQL Panels, you can increase the limit of records that by default is 200.
Not to be confused with the design panel, we are in the contextual menu to edit the first 200 rows and applying criteria to filter data. We can see the panels combined in the example, filtering waves with Power greater than fifty at a depth of less than 200 meters. In the middle panel, the assistant translates to the SQL language and the filtered data appears in the lower panel.
