Technical

How to edit more than 200 Rows in SQL Server Management 2014- Quick Fix

February 24, 2017

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.

The complete SQL Bootcamp will help you master your SQL skills very easily.

But one can change this setting and we will go through the process of modifying in this article.

Step 1:
  • Open up SQL server management studio 2014
  • 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
Step1Step 2: 
  • Go into Tools (it is available in header section of SSMS 2014)
  • Sub menu will appear
  • Click on “Options” to continue

Step2

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.

Step3

For this article, we have keyed in 2000, see below screen shot

Step4

Step 4:

Go back to the table name and right click and see the modified value.

Step5

Hope this helps, please comment below if this article has helped you.

Summary
How to edit more than 200 Rows in SQL Server Management 2014- Quick Fix
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.
Author
Publisher Name
www.aneetin.com
Publisher Logo

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.