【正文】 for interaction with the user, receiving user input and serverside data from present to clients. Business Logic Tier is responsible for receiving requests from browser requests to the data layers and at the same time the results of the request sent to the browser. It consists of Web Forms, XML Web services and service position ponents. Web Forms which is the core of the application, it is presented to customers based on data and information as well as to respond to and deal with customers and display interactive Web form generated based on information and data. Data layers to manipulate data through the layer for business logic to provide data services, such as storing the results of data manipulation and return to the results of data retrieval. The principle of access to the database Connected with the database, provide the following three kinds of ways: through ODBC connected。 many options including news categories, such as the source of departments only need to click the mouse can be pleted。 Guarantee the correctness of data storage。 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。 5 .import and export data。 the establishment and management of databases。 set task scheduling。 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。 backup databases and transaction logs, To restore database。 7. the client work。 3. Query Analyzer。 distributed database will ensure that any updates to distributed data integrity。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 s