Go How SQL Server 2008 edits more than 200 rows of data

Just changed SQL Server2008
Soon, the feeling of running speed, editing tips are more than the 05 version of the promotion, but in the maintenance test system encountered a 05 of the problem: 05 in the "Open Table" can edit all data rows, 08 to "Open the top 1000 lines" and "edit the Top 200 lines": The test system of data there are thousands of lines , how to edit the future data?


Method One: Modify the settings
Go to Tools---options---SQL server Object Explorer---command---edit <n> line, and change the value to 1000 (custom). Modified to:
Www.dedecms.com

Method Two: Modify the SQL statement



Open the table where you want to edit more than 200 rows, and then get the SQL statement on the right: [SQL] SELECT TOP (QuestionID),
Thechapter, Thetype, point, Degree, fraction, questioncontent, Blanknumber,
Isordinal, Correctanswer, isValid from
T_gangjinhunningtujiegou_tiankongti Modify the value in top () to