【正文】 the establishment of TransactSQL mand statements, as well as management and control of SQL Mail. 2. In Enterprise Manager contains two windows, the left side of the window as a tree shown in the active window, the contents of the right side of the window is displayed. 3. The left window click the plus sign to expand all the subproject contains. 4. An item by checking the node, you can see the right side of the window contains the contents of the project. Service Manager (Service Manager) SQL Server Service Manager is a serverside when the actual work of the most useful utilities, service manager to start, pause, continue and stop the database server in realtime services, the type of service provided, including: SQL Server, SQL Server Agent, Microsoft Search and Distributed Transaction Coordinator and so on. 。 to provide interserver control of the draganddrop operation。 set task scheduling。 backup databases and transaction logs, To restore database。 the establishment and management of databases。 7. the client work。 5 .import and export data。 3. Query Analyzer。 SQL Server 2020 relational database engine can fully protect data integrity, management of plications can also modify the database to minimize overhead. 4. Easy installation, deployment and use: SQL Server 2020 from a series of management and development tools, these tools made in a number of sites on the SQL Server installation, deployment, management and use easier. Developers can more quickly deliver SQL Server applications, and only require minimal installation and management of these applications can be achieved. 5. Data Warehouse: Data Warehouse is included in SQL Server 2020 for analysis of aggregate data access and analysis for online analytical processing tool. This feature is only in Oracle and other DBMS in the more expensive can. New Features of SQL Server 2020 Comprehensive SQL Server extends the performance, reliability and ease of use. Increase in a series of functions, as follows: 1. In regard to the strengthening of relational database 2. Enhanced graphical management 3. Enhance the joint database server Tools and utilities of SQL Server 2020 SQL Server 2020 there are eight tools are: 1. Enterprise Manager。 distributed database will ensure that any updates to distributed data integrity。 Guarantee the correctness of data storage。s Web site features news management system. 3 Systems Detailed Designs Core functions of the system through a number of functional modules achieved. Specific design process is as follows: ⑴ System login: The module responsible for the user are divided into general users and registered users to achieve the management of user rights. (2) News View: The module is responsible for all the news page web site lists information, including the title, type, source and date field departments, and each title has been made news a hyperlink, click the page they will be able to Jump news reader. (3) News reader: in other pages or click the title link to read into the news pages, at this time, detailed information of each information will be removed, including the content, title, keywords, and relatively fixed in accordance with the format placed in different pages region, the use of all the news about the same page layout, only the contents of the field corresponding to different In addition, the location of other pages can be dynamically placed in other ponents, such as web site logo, such as the page banner ads link to pictures, this can be easily to achieve the effect of illustrations in reading. (4) News Inquiry: The module provides a press inquiry, type to be selected to find the content and classification of information can quickly find the information in line with the conditions and results output. (5) News Management: The module listed in the registry is responsible for the registration page the user has issued a news and information and did not delete, the user can press to delete the article, modify. In addition to nonnews publisher is not outside the system administrator has the authority to deal with information which, so different users access to this page will display different content. (6) News entry and modification: a press registered users need to input the content, including title, ke