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

There are two options to edit more than 200 rows in SQL Management Studio

Option 1-changing the setting of 200 rows permanently:

Tools-->options-->SQL Server object explorer -->Commands
Edit "Change Value for Edit Top <n> Rows Command"



Option 2-changing the setting of 200 rows temporarily:

Right click Table-->click on Edit Top 200 Rows -->New Query window will be opened.

You can change the SELECT TOP (n) statement.

After changing it, click on the red exclamation mark (!) to update the selection.

 
 

Total votes: 263

Comments

Be the first one to write about this.

Your Comment

The content of this field is kept private and will not be shown publicly.
  • Lines and paragraphs break automatically.
Image CAPTCHA