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:

How to hide message window in MS SQL Server
Set Identity Insert On/Off in MSSQL
How to get triggers create and update date in SQL
How to solve 'incorrect syntax near the keyword WITH' problem?
Post Views: 111

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 *

May 2023
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Mar    

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (586)
  • Get the User Name and Domain Name from an Email Address in SQL (469)
  • Add Constraint to SQL Table to ensure email contains @ (358)
  • How to select distinct rows in a datatable in C# (302)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (296)
  • Average of all values in a column that are not zero in SQL (277)
  • Confirm before process with ASPxButton in Devexpress (273)
  • Find numbers with more than two decimal places in SQL (270)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (256)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (236)

Recent Posts

  • Solution for “utf8mb4 requires a newer client library” error in WordPress
  • How to use TrimEnd to remove last character from string in C#
  • What is the difference between “int” and “uint” / “long” and “ulong”?
  • How to solve the stucking on “Loading Packages” phase for SSMS installation
  • Geçmiş Olsun Türkiyem
  • What is the difference between ‘ref’ and ‘out’ keywords in C#
  • How to check if javascript is enabled on the client’s browser
  • How to disable ASP.Net button after click to prevent double clicking
  • What is the difference between HashSet and List in .net?
  • What is the purpose of nameof in C#?

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (586)
  • Get the User Name and Domain Name from an Email Address in SQL (469)
  • Add Constraint to SQL Table to ensure email contains @ (358)
  • How to select distinct rows in a datatable in C# (302)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (296)

Recent Posts

  • Solution for “utf8mb4 requires a newer client library” error in WordPress
  • How to use TrimEnd to remove last character from string in C#
  • What is the difference between “int” and “uint” / “long” and “ulong”?
  • How to solve the stucking on “Loading Packages” phase for SSMS installation
  • Geçmiş Olsun Türkiyem

Social

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

© 2023 ErcanOPAK.com

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