Two ways to edit more than 200 rows in SQL Management Studio

Here are 2 different solutions to a common problem.

Solution 1, changing the setting of 200 rows permanently:

In Management Studio’s top menu select Tools -> Options -> SQL Server Object Explorer –> Commands and change the setting you see below.

image

 

Solution 2, changing the setting of 200 rows temporarily:

When the Edit window has been opened you right-click on it and select Pane –> Sql like this.

image

This will open a Query box where you can change the SELECT TOP(nnn) statement used for editing. After changing it, click on the red exclamation mark (!) to update the selection.

image

As an extra bonus this method also makes it possible to select a subset of rows to be edited by using a WHERE statement.

Advertisements
Posted in SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s