Ring oss på +46 8 409 567 00 Kontakt

SSMS Tip – editing data

A quick SQL Server Management Studio tip should you ever need to edit a lot of data.

In the Object Explorer right click on table you need to change rows in and click on the edit menu

smss_edit1

The top 200 rows are shown in an editable grid, but what if these are not the rows you are looking for ? Easy – click the monochrome SQL button (not the SQL on a db icon with the blue tick – that checks your syntax)

smss_edit2

A new pane appears and you can improve the default query – here I am taking the top 500 rows instead and adding a WHERE clause to filter down to the rows I am “interested” in editing.

smss_edit3

Now edit the cells in the grid and remember your changes are not committed until you move the cursor to a different row.