How to Edit More than 200 Rows in SQL Server 2008 Management Studio
- by Chithra M
- in SQL Server
- on 4 Apr 2013
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.
© 2012 InApp Inc. All rights reserved