-63B5D53BB4DBC007517C2B9F8545E693 How to change SELECT Top 1000 rows or EDIT Top 200 rows Default Values in SQL Server Management Studio?

How to change SELECT Top 1000 rows or EDIT Top 200 rows Default Values in SQL Server Management Studio?

-

In SSMS when we want to view table records then it's only possible to SELECT top 1000 rows and EDIT top 200 rows by default. 

How to change SELECT Top 1000 rows or EDIT Top 200 rows Default Values in SQL Server Management Studio?

But sometimes when we want to retrieve more no of rows for SELECT and EDIT then what we can do? This article will explain how you can set custom limits for both these SELECT and EDIT top rows' operations.

Here are the steps to set custom limits for SELECT and EDIT top rows :

Step 1: Click on 'Tools' and then select 'Options'


How to change SELECT Top 1000 rows or EDIT Top 200 rows Default Values in SQL Server Management Studio?

Step 2: Expand 'SQL Server Object Explorer' option and then select 'Commands option'


- There are two options under 'Table and Views Options'. One is 'Value for Edit top <n> Rows command' and the second is 'Value for Select top <n>' Rows' command. 
-The first one is used to set EDIT top rows limit and another one is used to set SELECT top rows limit. Here you can change default values for both options and can set custom limits according to your needs.

Step 3: Set custom limits according to your needs

-Suppose if you set SELECT top rows limit to 1500 and EDIT top rows limit to 500 then next time when you right-click on any table then these changed limits will be displayed in option instead of the default.



-If you want to select all records for both SELECT and EDIT than you can set both 'Value for Edit top <n> Rows command' and 'Value for Select top <n>' Rows' options to '0'. If you set both options as 0 (zero) then the options will be displayed as 'Select All Rows' and 'Edit All Rows'.

           USEFUL CONTENTS

} 10 Legit Platform to make money from watching videos, Referring People, Taking Survey, Taking Quiz.






Post a Comment

Comment here

Previous Post Next Post

Facebook

close