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
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)
The menu location seems to have changed to:
Query Designer --> Pane --> SQL
Source: Stackoverflow.com