【正文】 the establishment and management of databases。 5 .import and export data。 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 New Features of SQL Server 2020Comprehensive 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 Tools and utilities of SQL Server 2020 SQL Server 2020 there are eight tools are: 1. Enterprise Manager。 Guarantee the correctness of data storage。 many options including news categories, such as the source of departments only need to click the mouse can be pleted。s activities and influence. Second， ASP and its advantage of function Advantages of ASP The use of ASP and SQL technology news site management system, to achieve the dynamic management of the news Web site, making the management of information more timely, efficient, improve the work efficiency. At the same time, the development of systems theory, systems and design features are introduced. With the popularization of Inter, more and more panies set up their own WWW sites, enterprises can display products through the website, publishing the latest developments, with users sharing and munication to establish contact with partners, as well as emerce. Information Management System which is an enterprise Web site an important part of it bears a double role, on the one hand, the dynamic can be used to release the new product or new development projects, on the other hand, the timely notice to their customers business performance, Progress in technology and research and development, in particular, remend or preferential projects, products and services to attract customers, expand customer base. Management of traditional news sites in two ways, one static HTML page, update the information needed to recreate the page and then upload the pageand modify the corresponding links, the efficiency of this approach is too low because we have little use. The second is based on ASP and scripting languages, dynamic Web pages and databases, through the application of procedures to deal with news, this is way more popular. However, due to the limitations of ASP allows the system itself, there are some insurmountable flaws, and technology has taken on the system performance has been greatly improved, the main performance in the following aspects: 1. ASP page to open as a result of each must be piled to explain the process, so whenthe page opens in the rate of repeated there is no upgrade, and only need a page do not need to repile piled until the page has been modified or Web Application process restarted. This makes the speed in a number of visits has greatly improved. 2. As the ASP does not provide any output data for the content of the ponents, so writing a database using ASP page can use the Record Set Object ADO to read records of transaction, while the ASP provided through the DataGrid, such as database and database ponents can be directly Contact. 3. ASP support realtime application updates. Administrators do not have to turn off the work server or even do not have to stop running the application can update the application on file. Application documents will never be locked, so even when the program runs in the paper can be overwritten. When the document is updated, the system will convert to the new moderate version. 4. ASP take the codebehind approach to the preparation of the code makes the code easier to prepare, structure more clearly, reducing the system development and maintenance of the plexity and the cost of. The function of ASP The use of Active Server Pages can plete the following work: 1, to generate dynamic Webpage. At different times of the day, or for different users, the Active Server Pages can display different content. 2 HTML, the contents of the form. The use of Active Server Pages can obtain and respond to input the HTML form data. 3, the creation of database driven Webpage. Active Server Pages from Microsoft SQL as Server like database access to existing data or to insert new data. 4, tracking the user session. From the user to your site until the left, you can use Actire Server Pages to store the information. 5, to create a searchable Webpage. With the Microsoft Index Server or Microsoft SQL Server text retrieval when used together with Active, Server Pages can create a web site search engine. 6 different browsers, retrieval function. Characteristics of Active Server Pages can support retrieval browser and display for different browser content. 7, send and receive . Active Server Pages automatically to the user to send and receive sent to the site. 8, the custom ponent with the web site together. Microsoft Script Componts, Microsoft Visual Basic user serverside ponents or Microsoft Visual C++ to create the Active Server Pages script can be extended. Third， System Development Principle The System Architecture Model of ASPbased Technology ASP is a threetier system structure UI Layer, Business Logic Tier and data layer. UI lay