[sql-server-2008] How to edit one specific row in Microsoft SQL Server Management Studio 2008?

In Microsoft SQL Server Management Studio 2008, is there a secret to be able to edit one row based on a key?

There's an option to do "Edit Top 200 Rows", but what if I want to select some other row and edit it in the datagrid? I would rather do that than code an update statement and risk messing up the where clause.

This question is related to sql-server-2008 ssms

The answer is


How to edit one specific row/tuple in Server Management Studio 2008/2012/2014/2016

Step 1: Right button mouse > Select "Edit Top 200 Rows"

Edit top 200 rows

Step 2: Navigate to Query Designer > Pane > SQL (Shortcut: Ctrl+3)

Navigate to Query Designer > Pane > SQL

Step 3: Modify the query

Modify the query

Step 4: Right button mouse > Select "Execute SQL" (Shortcut: Ctrl+R)

enter image description here


The menu location seems to have changed to:

Query Designer --> Pane --> SQL