Unreasonable design of querying and modifying data in SQL Server 2005 _php Tutorial

Source: Internet
Author: User
Tags management studio sql server management sql server management studio
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 ..."

  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.