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:

Edit top 200 rows option in MSSQL Management Studio

Then right click in the new window that just opened and select Pane -> Criteria:

The Criteria view of tables data

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

Add a filter and execute the SQL

comments powered by Disqus