SQL Server 2008 - Go From Select to Edit Quickly

Question

In server management studio 2008 you can right mouse click on a table and then hit the select the first 1000 rows. Is there a button or a quick way to edit one of the returned rows instead of having to right mouse click on the table again and click edit first 200 rows.

Answer 1

Here's the way I normally go about this:

1. Right-Click table and select "Edit Top 200 Rows"

2. Right-Click anywhere on the results, navigate to Pane -> SQL

You'll see a SELECT statement that begins with

SELECT TOP(200) .....

Change the "200" to a larger value, or add a WHERE clause at the bottom.