How to edit more than 200 Rows in SQL Server Management 2014- Quick Fix
February 24, 20171
In this article, we will go through the process of changing modifying the number of rows while displaying for a particular table. As a standard within SQL Server Management Studio 2014, for a particular table user will be able to edit only Top 200 Rows.
Go into the Database and specific table where you want to modify the value.
Right click on the table, it will show you the standard option of edit top 200 rows
Step 2:
Go into Tools (it is available in header section of SSMS 2014)
Sub menu will appear
Click on “Options” to continue
Step 3:
More options are displayed on the screen.
One has to click on “SQL Server Object Explorer”
On right-hand side look for Table and View options
Enter desired value that you want to Edit for a table and click on Save.
For this article, we have keyed in 2000, see below screen shot
Step 4:
Go back to the table name and right click and see the modified value.
Hope this helps, please comment below if this article has helped you.
Summary
Article Name
How to edit more than 200 Rows in SQL Server Management 2014- Quick Fix
Description
In this article, we will go through the process of changing modifying the number of rows while displaying for a particular table. As a standard within SQL Server Management Studio 2014, for a particular table user will be able to edit only Top 200 Rows.
[…] Read more: How to edit top 200 rows in SQL […]