Edit Top 200 Rows Change. Say edit top 200 rows like usual then right click in the result set and say pane sql. But when i do choose edit top 200 rows i dont have the ability to alter the sql which makes it hard to find and edit a record just added in the 10000 that are there.
The sql server 2005 management studio allows us to edit and view the whole set of records in a table. Let us see how to alter select top 1000 rows and edit top 200 rows default value in ssms. You can do this in ssms.
Change the settings in the sql server management studio to display all the rows by following the steps as shown.
Value for select top rows command. Select sql server object explorer. Now go back and right click on your table. Proceed with caution though theres a reason microsoft put these.