To make changes to table data using a view
Expand the database that includes the view in Object Explorer, then Views.
Select Edit Top 200 Rows from the context menu when you right-click the view.
To return the rows to be updated, you may need to edit the SELECT statement in the SQL pane.