sqlserver--Baidu Encyclopedia

SQL is an abbreviation for the English Structured Query language, meaning Structured query language. The main function of the SQL language is to connect with various databases and communicate with each other. According to ANSI (National Standards Association), SQL is used as the standard language of the relational database management system. SQL Server is a relational database management system (DBMS) developed and promoted by Microsoft.

Chinese name

Sql server

Foreign names

structured Query Language

Interpretation

Structured Query Language

function

Networking

with various databases

Directory

1. 1 relational database introduction
2. < Span class= "index"? features
3. configuration requires
4. 2 details
5. sqlserver version
6. sql Server 2008 new features

Introduction to relational databases edit SQL Server is a relational database management system (DBMS) developed and marketed by Microsoft, originally developed by Microsoft, Sybase, and ashton-tate three companies, and launched in 1988 with the first os/ Version 2. Microsoft SQL Server has been updating its version in recent years, Microsoft introduced the SQL Server 6.5 version in 1996, 1998, SQL Server 7.0 version and user meeting; SQL Server 2000 was introduced in 2000 by Microsoft Corporation, and the latest version is SQL SERVER 2012, which was launched in March 2012. Features 1. A true client/server architecture. 2. Graphical user interface makes system management and database management more intuitive and simple. 3. Rich programming interface tools provide users with a greater choice of programming. 4. SQL Server is fully integrated with Windows NT, leveraging many of the features of NT, such as sending and receiving messages, managing login security, and more. SQL Server can also be well integrated with Microsoft BackOffice products. 5. Provides good scalability across multiple platforms, from laptops running Windows 95/98 to large multi-processors running Windows 2000. 6. Support for Web technologies enables users to easily publish data from a database to a Web page. 7. SQL Server provides data warehousing capabilities that are only available in Oracle and other more expensive DBMS. SQL Server 2000 has the following new features compared to previous versions: 1. Supports XML (extensive Markup Language, Extensible Markup Language) 2. Powerful web-based analytics 3. Supports OLE DB and multiple queries 4. Support for distributed partitioned view configuration requires hardware requirements for installation, running SQL Server 2000 1. Computer Intel and its compatible computer, Pentium 166Mz or higher processor or DEC Alpha and its compatible system. 2. Memory (RAM) Enterprise Edition minimum of 64MB memory, other versions require a minimum of 32MB of memory, it is recommended to use more memory. 3. Hard disk space fully installed (full) requires 180MB of space, typical installation (typical) requires 170MB of space, Minimum installation (Minimum) requires 65MB of space. Detailed introduction Edit SQL statements can be used to perform a variety of operations, such as updating data in a database, extracting data from a database, and so on. Currently, the vast majority of popular relational database tubessuch as Oracle,sybase,microsoft SQL Server,access, etc., have adopted the SQL language standard. Although many databases have been re-developed and extended for SQL statements, standard SQL commands, including select,insert,update,delete,create, and drop, can still be used to perform almost any database operation. SQL Serversql Server is a relational database management system. Originally developed jointly by Microsoft Sybase and ashton-tate three companies, it launched the first OS/2 version in 1988. After the launch of Windows NT, Microsoft and Sybase split up on SQL Server development, and Microsoft migrated SQL Server to the Windows NT system, focusing on developing windows for promoting SQL Server NT version. Sybase is more focused on the application of SQL Server on UNIX operating systems. SQL Server 2000 is a SQL Server database management system introduced by Microsoft Corporation that inherits the benefits of the SQL Server 7.0 version and adds many more advanced features than it does. With ease of use scalability and the high degree of integration of related software, you can span multiple platforms, from laptops running Microsoft Windows 98 to large multiprocessor servers running Microsoft Windows 2000. SQL Server 2000: A SQL Server database management system introduced by Microsoft Corporation that inherits the benefits of the SQL Server 7.0 version and adds many more advanced features than it does. With ease of use scalability and the high degree of integration of related software, you can span multiple platforms, from laptops running Microsoft Windows 98 to large multiprocessor servers running Microsoft Windows 2000. SQL Server 2005 is a comprehensive database platform that provides enterprise-class data management with integrated Business Intelligence (BI) tools. The SQL Server 2005 Database engine provides more secure and reliable storage capabilities for relational and structured data, enabling you to build and manage high-availability and high-performance data applications for your business. SQL Server 2005:sql Server 2005 The data engine is at the heart of this enterprise data management solution. In addition, SQL Server 2005 combines analysis, reporting, integration, and notification capabilities. This enables your enterprise to build and deploy cost-effective BI solutions that help your team bring data to the business through scorecards, Dashboard, Web services, and mobile devices. Tight integration with Microsoft Visual Studio, the Microsoft Office System, and the new development kit, including business Intelligence development Studio, enables SQL Server 2005 different. Whether you're a developer, database administrator, information worker, or decision maker, SQL Server 2005 can provide you with innovative solutions to help you gain more from your data. SQL Server 2008:sql Server 2008 is a major product release that has introduced many new features and key improvements that make it the most powerful and comprehensive version of SQL Server so far. This article details the new features, benefits, and features in Microsoft SQL Server 2008 ... Microsoft's data platform meets the needs of these data explosions and next-generation data-driven applications to support the data platform vision: mission-critical enterprise data platforms, dynamic development, relational data, and business intelligence. Many factors have led to the explosion of information storage. With the new information types, the digitization of samples and videos, and the sensor information obtained from RFID tags, the number of company digital information is growing sharply. Adherence to norms and the development of globalization requires the security of information stores and is available at all times. At the same time, the cost of disk storage is significantly reduced, allowing the company to store more data for each dollar invested. The user must quickly find the relevant information in a large amount of data. In addition, they want to use this information on any device and plan to use it on a daily basis, such as Microsoft Office System applications. The increased management of data explosion and user expectations has created many challenges for the company. microsoft&reg; The Data platform Vision provides a solution to meet these needs, the solution is that companies can use to store and manage many data types, including XML, e-mail, time/calendar, files, documents, geography and so on, while providing a rich set of services to interact with the data: Search, query, Data analysis, reporting, data consolidation, and powerful synchronization capabilities. Users can access information from the creation to the archive on any device, from the desktop to the mobile device. SQL Server 2008 New features this platform has the following features：· Trusted-enabling companies to run their most mission-critical applications with high security, reliability, and scalability. Efficient-enables companies to reduce the time and cost of developing and managing their data infrastructures. Smart-Provides a comprehensive platform to send observations and information to your users when they need them. One, trustworthy (a) to protect your information on the basis of previous SQL Server 2005, SQL Server 2008 has made the following enhancements to extend its security: * Simple Data encryption SQL Server 2008 can be used for the entire database, Data files and log files are encrypted without the need to alter the application. Encryption enables companies to meet compliance and their concerns about data privacy requirements. The benefits of simple data encryption include searching for encrypted data using any scope or fuzzy query, enhancing data security to prevent unauthorized user access, and data encryption. These can be done without changing the existing application. * FOREIGN Key Management SQL Server 2008 provides a comprehensive solution for encryption and key management. To meet the growing need for stronger security in data center information, companies invest in suppliers to manage security keys within the company. SQL Server 2008 provides a good support for this requirement by supporting third-party key management and hardware security Module (HSM) products. * Enhanced Review SQL Server 2008 enables you to review your data operations, resulting in improved compliance and security. The review includes not only all information about the data modifications, but also information about when to read the data. SQL Server 2008 has features such as the configuration and management of enhanced reviews in servers that enable companies to meet a variety of regulatory requirements. SQL Server 2008 can also define a review specification for each database, so a review configuration can be made separately for each database. A review configuration for the specified object makes the review perform better and the configuration more flexible. (ii) Ensuring business sustainability * Improved database mirroring SQL Server 2008 based on SQL Server 2005 and provides a more reliable platform for enhancing database mirroring. The new features include: • The page is automatically repaired. SQL Server 2008 obtains a re-copy of the error page from the mirrored partner machine, enabling the primary and mirrored computers to transparently fix the 823 and 824 errors on the data page. • Improved performance. SQL Server 2008 compresses the output log stream so that the network bandwidth required for database mirroring is minimized. SQL Server server installation Anatomy of a previous version of SQL Server 2000, such as 7.0There are generally no more than one version, only the standard version and the desktop version, if the user is not clear what version to install, you can follow the installation of the installation prerequisite instructions installed, generally in the WIN2000 server version of the standard version, the other system installed on the desktop version can be, and SQL Server 2000 installation problem is relatively large, Frequently asked questions are as follows: (1) interrupt when configuring the server. (2) interrupt when registering ActiveX. (3) The interrupt is displayed to 100%. (4) Hint: command line option Syntax error,type command/? For help, continue the installation, and finally appear when configuring the server: Unable to find dynamic link SQLUNIRL.DLL to the specified path ... (5) The previous program created a pending file operation, before running Setup, the workaround for (1) (2) (3) must be restarted: reminder: To avoid misoperation, back up the registry and the database before SQL Server 2000, you can back up program files\ Files for the Microsoft SQL server\mssql\data folder. 1. First of all, the SQL Server uninstall (uninstall does not have a relationship, continue the following operation) 2. Erase the entire Microsoft SQL Server folder. 3. Run the registry and delete the following: HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL serverhkey_local_machine\software\microsoft\ Microsoft SQL serverhkey_local_machine\software\microsoft\mssqlserver4. Restart the system 5 if needed. Reinstall Alternatively, you can also try to run the installation of SQL Server 2000 in a single step: 1: Put the SQL Server 2000 disc. 2: In Start--run, type F:\x86\setup.exe k=dbg (F is a disc) Note: I. Different operating systems support the version of SQL Server 2000 and the requirements for hardware. Windows Update server can install any version of SQL Server 2000. Windows Professional can only install personal, development, evaluation, MCDE, SQL Server 2000, and hardware requirements for SQL Server 2000. (4) solution because the path to the installation file (full path) is in Chinese. Like C.: \SQLServer Chinese Enterprise version \ Change to c:\SQLSERVER\ (5) solution A, restart the machine, and then install, if you find that the error, please follow step b below, enter REGEDITC in the start-to-run, to Hkey_local_ MACHINE\System\CurrentControlSet\Control\Session Manager position D, select File--pour out, save E, right-click PendingFileRenameOperations in the right window, Select Delete, then confirm F, restart the installation, solve the problem-------------------------------------------------------if the problem persists, try repairing the operating system command prompt to execute: sfc/ Scannow Last method: Change the Windows 2000 Setup disk and the SQL Server2000 Setup disk Sometimes the reason for the problem is strange, someone has replaced a power supply to solve the problem. 1. Uninstall your SQL Server 2000 first, and delete Program Files\Microsoft SQL Server folder 2 if necessary. Open the registry at "start"--"Run" type "regedit" 3. Click on Open + hkey_local_machine+ softwart+ microsoft+ windows+ currentversion+ setup+ EXCEPTIONCOMPONENTS4 in the following order. Delete all the folders below Exceptioncomponents! such as {60bff50d-fb2c-4498-a577-c9548c390bb9}{60bff50d-fb2c-4498-a577-c9548c390bb9}{ 60bff50d-fb2c-4498-a577-c9548c390bb9}{60bff50d-fb2c-4498-a577-c9548c390bb9}6. Reboot: 7. Reinstall the SQL Server 2000XP+SP2 issue 1. The WINXP+SP2 system needs to install SQL Server SP3 (Service Pack patch 3) and must be installed again if it was previously installed. SP3 can be downloaded free of charge on Microsoft website, the Chinese version address is as follows: SQL Server Service Pack 3a

sqlserver--Baidu Encyclopedia