SQL Server 08 - way to edit one specific row in the GUI

Question

In Microsoft SQL Server Management Studio 2008 - is there not a secret to being 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 data-grid? I would rather do that than code an update statement and risk messing up the where clause.

Is there some secret option to switch the query view into an edit view? Wouldn't the designers of this tool thought of that? Maybe it's there and I'm just unaware of it.

Thanks,

Neal Walters

Answer 1

Writing a SELECT statement that selects from the given table a specific row will show it in the grid & you should be able to edit it.

e.g.

SELECT *
FROM myBigTable
WHERE ID = someIdIWantToEdit

Answer 2

Use the "Edit top 200" option, then click on "Show SQL panel", modify yoru query with your WHERE clause, and execute the query. You'll be able to edit the results.