You are here
Home > How To > Select and Edit all rows in SQL Server 2012

Select and Edit all rows in SQL Server 2012

SQL Server 2012 Select top 1000 rowsIf you use SQL Server Management Studio often, you will have noticed that from the context menu that is displayed when right clicking on a table, there are two options (among the others) namely “Select Top 1000 Rows” and “Edit Top 1000 Rows”. The purpose of these menu options are self evident. But wouldn’t you like to be able to select or edit all the rows in a table? Well the good news is that you can by following these steps:





  1. Click on Tools in the menu, and then Options.
  2. Select SQL Server Object Explorer. From the options on the right hand side, you should be able to see the following:
  • Value for Edit Top <n>Rows Command
  • Value for Select Top <n> Rows Command

You can obviously change the values for each as you wish (for example 2000 for select top 2000 rows), but if you would like to select and edit all the rows, change these values to 0.

Change Select and Edit Rows Option in SQL Server












Now if you go back into SQL Server Management Studio and right click on a table, you will see that the Context Menu options have changed to “Select All Rows” and “Edit All Rows”.

SQL Server 2012 Select or Edit All Rows












If you have some nice SQL Server tips that you would like to share, please let us know by leaving a comment in the section below.

[Original Post by Senthil Kumar]

Dirk Strauss
Dirk is a Software Developer and Microsoft MVP from South Africa. He loves all things Technology and is slightly addicted to Twitter and Jimi Hendrix. Apart from writing code, he also enjoys writing human readable articles. "I love sharing knowledge and connecting with people from around the world. It's the diversity that makes life so beautiful." Dirk feels very strongly that pizza is simply not complete without Tabasco, that you can never have too much garlic, and that cooking the perfect steak is an art he has yet to master.