Edit multiple rows in MSSQL after filtering the table
The past days I had to change multiple rows of an MSSQL table after filtering its content with a WHERE clause.
For this task you get great support from MSSQL Management Studio by using the criteria view of the tables data.
First right click on the table you want to edit and select the edit top 200 rows option:
Then right click in the new window that just opened and select Pane -> Criteria:
Now you get a dialog with options about sorting and filtering the data of the table. In the following example we add a filter and with right click we select *Execute SQL** to run our query. The filtered results are shown on the bottom area of the window