In SQL Server 2000, we want to modify the data directly in the database table, the general way is: In SQL Server Enterprise Management, select the appropriate table, right-click, in the Open Table select query, in the SQL edit window, enter the SQL statement to find the record to modify, The corresponding fields are then modified directly in the results window.
What do you need to do in SQL Server 2005?
In SQL Server Management Studio, locate the appropriate table, right-click, select "Open table", and then click the "Show SQL Pane" button to enter the SQL statement in the SQL Pane window to find the records you want to modify. The corresponding fields are then modified directly in the results window.
You might think that SQL Server 2005 is no different from SQL Server 2000 operations.
But the problem is that when you select Open Table, when open table, SQL Server Management Studio executes all the records in the query table, and if there is a lot of data in the table, there will be a time to wait for the query, and you will be annoyed at the wait. Because you just want to change a record, the query is simply superfluous. There is also "Open Table" in SQL Server 2000, and all records are queried, but SQL Server 2000 also provides a "query" operation, which is how the article begins.
You might say that the "Script table as" operation is provided in SQL Server Management Studio, but the result of the select to query through the Script table as is read-only and cannot be modified. It is inconvenient to operate through "Update to" because in most cases, you need to look at the original data before modifying the data. If you update directly, you may not have expected modifications due to incorrect conditions in the SQL statement.
I am also just in touch with SQL Serve r2005, perhaps SQL Server 2005 provides other handy ways to do it, but I didn't find it. If you know, you're welcome to tell me.
Source: dudu-Happy Programmer
http://www.bkjia.com/PHPjc/631025.html www.bkjia.com true http://www.bkjia.com/PHPjc/631025.html techarticle In SQL Server 2000, we want to modify the data directly in the database table, the general way is: In SQL Server Enterprise Management, select the appropriate table, right-click on the "Open Table ..."
