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