Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About
SQL

Change Default Value for “Select Top n” and “Edit Top n” Rows in SQL Server Studio

- 20.01.19 | 22.11.19 - ErcanOPAK

In SQL Server Management Studio, by default you can only Select Top 1000 Rows or Edit Top 200 Rows for a table as shown in the below snippet.

in sql server 2008 management studio you can only select the top 100 rows

The default option as shown above is to Select Top 100 Rows or Edit Top 200 Rows. This can be changed by following these steps.

1. In SQL Server Management Studio, under Tools, click Options as shown in the snippet below.

in ssms under tools, click options

2. In the Options dialog box, expand SQL Server Object Explorer and then select the Commands tab as shown in the snippet below. Change the Value for Edit Top Rows command and/or Value for Select Top Rows command to a suitable value as per your needs as shown in the below snippet and then click OK.

expand sql server object explorer

3. Once you have saved the changes go ahead and right click on a table to see the changes as shown below.

sql server 2008

Related posts:

Not Null check on LEFT function with T-SQL
How to get triggers create and update date in SQL
How to solve “A cursor with the name already exists” problem?
Add Constraint to SQL Table to ensure email contains @
Post Views: 114

Post navigation

Website Suggestions: LetterBoxD & GoodReads
Drag and Drop objects from Object Explorer to the Query Window in SQL Server

Leave a Reply Cancel reply

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

December 2023
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Nov    

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (703)
  • Get the First and Last Word from a String or Sentence in SQL (697)
  • How to select distinct rows in a datatable in C# (559)
  • Add Constraint to SQL Table to ensure email contains @ (455)
  • Average of all values in a column that are not zero in SQL (372)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (343)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (338)
  • Find numbers with more than two decimal places in SQL (324)
  • Confirm before process with ASPxButton in Devexpress (316)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (292)

Recent Posts

  • How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger
  • How to convert JPG or PNG to WebP in batch or single mode
  • How to get the first and the last day of previous month in SQL Server
  • Not Null check on LEFT function with T-SQL
  • NICE 100 YILLARA TÜRKİYEM
  • How to delete all commit history in github
  • How to display HTML components on the same line in CSS
  • How to insert results of a stored procedure into a temporary table
  • How to remove all non alphanumeric characters from a string in C#
  • How to get the Xth Day of the Week of the Year in C#

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (703)
  • Get the First and Last Word from a String or Sentence in SQL (697)
  • How to select distinct rows in a datatable in C# (559)
  • Add Constraint to SQL Table to ensure email contains @ (455)
  • Average of all values in a column that are not zero in SQL (372)

Recent Posts

  • How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger
  • How to convert JPG or PNG to WebP in batch or single mode
  • How to get the first and the last day of previous month in SQL Server
  • Not Null check on LEFT function with T-SQL
  • NICE 100 YILLARA TÜRKİYEM

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter

© 2023 ErcanOPAK.com

Proudly powered by WordPress | Theme: Xblog Plus by wpthemespace.com