How to Edit More than 200 Rows in SQL Server 2008

How to Edit More than 200 Rows in SQL Server 2008 Management Studio

Step 1: In SQL Server 2008 Management Studio,

go to "Tools" -> "Options" -> "SQL Server Object Explorer" -> "Commands".

Step 2: Now in "Table and View Options" section, you can change either:

#Value for Edit Top Rows command, to a value greater than or less than 200.
#Value for Select Top Rows command, to a value greater than or less than 1000.

Step 3: By specifying a value of 0, SQL Server will return all rows.

(If you sql tables are really large data volume, you should NOT set these values to 0.)

Step 4: Click OK to save your changes.

Comments

Popular posts from this blog

Auto Sequence Number in Grid Control with Paging

Polymorphism in C#

Print Function By JavaScript

Variable Value in Top Statement

How to Update Dependent Excel Cells Automatically

Auto Refresh .aspx page - ASP.NET

Paged Data Source - Custom Paging