How to edit one specific row in Microsoft SQL Server Management Studio 2008?
Sql Server-2008SsmsSql Server-2008 Problem Overview
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.
Sql Server-2008 Solutions
Solution 1 - Sql Server-2008
Use the "Edit top 200" option, then click on "Show SQL panel", modify your query with your WHERE clause, and execute the query. You'll be able to edit the results.
Solution 2 - Sql Server-2008
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"
Step 2: Navigate to Query Designer > Pane > SQL (Shortcut: Ctrl+3)
Step 3: Modify the query
Step 4: Right button mouse > Select "Execute SQL" (Shortcut: Ctrl+R)
Solution 3 - Sql Server-2008
The menu location seems to have changed to:
Query Designer --> Pane --> SQL
Solution 4 - Sql Server-2008
If you are facing challenges in saving data from the results pane after using Edit Top 200 Rows option, then the below steps are for you:
- Run the query or view that has the data you want to edit.
- Navigate to the cells containing the data you want to change.
- Type in the new data.
- Save your changes by leaving the row.
Ref: MS Docs