SQL Server 2008 edit all or any line

Select the table right-click on "Edit Top 200 rows" and select the upper-left corner of the

SQL icon, then on the right side of the SQL statement to remove the top 200 and then execute the query to edit all the rows, you can choose to write SQL, and then query editing.

The second way: You can filter the data you need by selecting the first 200 rows before you open the Show Criteria pane mate condition, so you don't need to write the SQL statements manually. Instead, SQL Server comes to completion.

Can be used according to personal preferences.

SQL Server 2008 edit all or any line