How to edit more than 200 rows in SQL Server Management Studio

← PrevNext →

By default, you can Edit Top 200 rows in a table from SQL Server Management Studio. So, when you right click a table, it shows an option Edit Top 200 rows. And, you wonder how do I edit more than 200 rows. You’ll have to make some changes to the default settings.

Just follow these steps.

1) From the top menu, choose Tools and select options.


Options in SQL Server Management Studio

2) In the options window, select SQL Server Object Explorer -> Commands.

3) Finally, in Table and View Options, change the value from 200 to a larger value like (2000) in Value for Edit Top <n> Rows command. See the image.


Edit more than 200 rows in SQL Server Management Studio

4) Press Ok. Its done. Now you can edit 2000 rows (or any larger value that you have selected) in a table.

Remember: SQL Server will apply these changes to all the tables in all the databases.

1) How to find and remove Duplicate rows in a Table using SQL Server ROW_NUMBER() and CTE: Duplicate rows in tables can be very annoying for DBA’s and programmers, as it raises many uncomfortable questions about the authenticity of data in a database. The matter gets worse when company auditors complain about irregularities in the balance sheet etc.

2) How to convert Rows into Columns using SQL Server PIVOT OR how to use PIVOT in SQL Server: Ever wondered how you can convert data from rows to columns in SQL Server. We are talking about an SQL query, which will transform records from multiple rows into columns. Using SQL Server PIVOT, we can efficiently rotate a table’s data to show a summarized result.

3) Insert Multiple rows with a Single INSERT Statement using SQL Server Table Value Constructor: While managing an Inventory management System for an organization, I have came across a situation where I had to perform bulk upload on a table in SQL Server. Bulk upload requires inserting multiple rows of data in a table.

4) How to Convert Month Number in a Date to Month Name in SQL Server: Let us assume I have a Sales table with sales data for each month. Every day sales is stored in the table with columns such as date, quantity, price etc. I want to get the total sales for every month. Now since I have a column with “date” data type, I want to convert the month number in the date to Month Name (like February, March etc.). Find out how this is done in SQL Server.

5) SQL Server CHARINDEX Function with Examples: The primary use of an SQL Server CHARINDEX function is to find the first or starting location of an expression or characters in a given string. To make it simple, it is like searching a specified character or characters in a string.

← PreviousNext →