SQL is the acronym for Structured Query Language in English, meaning a structured query language. SQL language is the main function to establish contacts with various databases, for communication. In accordance with the ANSI (American National Standards Institute) requirements, SQL is a relational database management system as the standard language.
directory
About us features of the relational database configuration requirements detailed Sqlserver new version of SQL Server 2008 Introduction to SQL Server relational database functionality by Microsoft development and promotion of the relational database management system (DBMS),
nike air force 1, it was originally by the Microsoft, Sybase and Ashton-Tate three companies jointly developed and launched in 1988 the first OS / 2 version. In recent years, constantly updated version of SQL Server 1996, Microsoft launched the SQL Server 6.5 version; 1998, SQL Server 7.0 version, and users to meet; SQL Server 2000 is Microsoft Corporation in the latest version was introduced in 2000. Features 1. True client / server architecture. 2. Graphical user interface, the system management and database management more intuitive and simple. 3. Rich programming interface tool for users to program design provides greater choice. 4. SQL Server is fully integrated with Windows NT, use NT's many features, such as send and receive messages, manage logon security. SQL Server can also be well integrated with Microsoft BackOffice products. 5. Has good scalability,
air force one low, across from a laptop running Windows 95/98 to run Windows 2000 and other large-scale multi-processor platform. 6. Technical support on the Web, enabling users to easily publish data in the database Web page. 7. SQL Server provides data warehousing capabilities, this feature only in Oracle and other DBMS in only more expensive. SQL Server 2000 compared with the previous version, but also has the following new features: 1. Support for XML (Extensive Markup Language, Extensible Markup Language) 2. Powerful Web-based 3. Supports OLE DB and a variety of query 4. Support the distributed partitioned view configuration required to install, run the hardware requirements for SQL Server 2000 (1) Computer Intel and compatible computer, Pentium 166Mz or higher processor or DEC Alpha and its compatible systems. (2) Memory (RAM) Enterprise Edition least 64MB of memory, the other version requires a minimum of 32MB RAM is recommended to use more memory. (3) a full installation of hard disk space (Full) requires 180MB of space, a typical installation (Typical) requires 170MB of space, minimal installation (Minimum) requires 65MB of space. Detail SQL statement can be used to perform various operations, such as updating data in the database, extract data from the database and so on. Currently, the vast majority of the popular relational database management systems such as Oracle, Sybase, Microsoft SQL Server, Access, adopted the standard SQL language. Although many databases on the SQL statement for the redevelopment and expansion, but including the Select, Insert, Update, Delete, Create, and Drop, including the standard SQL commands can still be used to complete almost all the database operations. SQL Server SQL Server is a relational database management system. It was originally developed by Microsoft Sybase and Ashton-Tate three companies jointly developed in 1988 launched the first OS / 2 version. In the introduction of Windows NT, Microsoft and Sybase in SQL Server parted ways on the development, Microsoft SQL Server will be ported to Windows NT system, focusing on promoting the development of SQL Server in Windows NT version. Sybase SQL Server are more focused on the UNIX operating system applications. SQL Server 2000 is Microsoft has introduced SQL Server database management system, the version of SQL Server 7.0 version inherits the advantages of both off than it increases the number of the more advanced features. Good scalability with ease of use and advantages of highly integrated software can be running Microsoft Windows 98 across from the laptop computer running Microsoft Windows 2000, large multi-processor server and other platforms. Sqlserver version of SQL Server 2000: Microsoft has introduced a SQL Server database management system, the version of SQL Server 7.0 version inherits the advantages of both off than it increases the number of the more advanced features. Good scalability with ease of use and advantages of highly integrated software can be running Microsoft Windows 98 across from the laptop computer running Microsoft Windows 2000, large multi-processor server and other platforms. SQL Server 2005 is a comprehensive database platform, with integrated business intelligence (BI) tools provide enterprise-class data management. SQL Server 2005 relational database engine for data and structured data to provide a more secure and reliable storage, so you can build and manage high availability and high performance for business data applications. SQL Server 2005: SQL Server 2005 data engine is the enterprise data management solutions for the core. Also SQL Server 2005 combines the analysis, reporting, integration,
nike air force one high, and notifications. This allows your business to build and deploy cost-effective BI solutions that help your team through the scorecard, Dashboard, Web services and data applications to mobile devices business in various fields. And Microsoft Visual Studio, Microsoft Office System and the new development kit (including the Business Intelligence Development Studio) to the close integration of SQL Server 2005 apart. Whether you're a developer, database administrator, information worker, or decision maker, SQL Server 2005 can provide you with innovative solutions to help you benefit more from the data. SQL Server 2008: SQL Server 2008 is a major product release, it introduced many new features and key improvements, making it the most powerful to date and most comprehensive version of SQL Server. This article introduces Microsoft SQL Server 2008's new features, advantages and features ... ... Microsoft's data platform to meet these data explosion and the next generation of data-driven application requirements, support data platform vision: mission-critical enterprise data platform, dynamic development, relational data and business intelligence. Many factors have resulted in the information storage explosion. With the new information types, such as digital pictures and video, and RFID tags available from the sensor information, the number of the company's digital information is increasing rapidly. Compliance with specifications and requirements of the development of globalization of information security and storage are available at any time. Meanwhile, the cost of disk storage was significantly reduced, making every dollar invested can store more data. The user must in large amounts of data quickly find the relevant information. In addition, on any device they want to use this information, and plan to use every day, such as Microsoft Office system applications. Data explosion and the increase in the management of user expectations for the company has created many challenges. Microsoft ® data platform vision to provide a solution to meet these needs, this solution is that companies can use to store and manage many data types, including XML, e-mail, time / calendar, files, documents, geographic, etc. while providing a rich set of services to interact with the data: search, query, data analysis, reporting, data integration, and strong synchronization. Users can access from the creation to archive to any device,
air force 1 shoes, from desktop to mobile device features information about SQL Server 2008 this platform has the following features: • Trusted - allows the company to a very high security, reliability and scalability to run their most mission-critical applications. • Efficient - enables companies to reduce development and management of their data infrastructure of the time and cost. * Intelligence - provides a comprehensive platform for your users need to give him the time to send observation and information. First, the trusted (a) to protect your information in the past based on SQL Server 2005,
nike air force one, SQL Server 2008 made the following enhancements to extend its security: * a simple data encryption to the entire SQL Server 2008 databases, data files and log file encryption, without the need for changes to the application. Encryption so that companies can meet compliance standards and its focus on data privacy requirements. The benefits of a simple data encryption, including the use of any range or fuzzy query search encrypted data, enhancing data security to prevent unauthorized user access, as well as data encryption. These can not change the existing circumstances the application. * Foreign key management for the SQL Server 2008 encryption and key management provides a comprehensive solution. In order to meet the evolving information on data center needs more security, the company invested to the supplier to manage security keys within the company. SQL Server 2008 by supporting third-party key management and hardware security module (HSM) products for the needs of a very good support. * Enhanced the review of SQL Server 2008 allows you to review the operation of your data, resulting in improved compliance and security. Review not only includes all the information on data changes, but also about when reading the data information. SQL Server 2008 has strengthened the review as server configuration and management of such a function, which allows the company to meet various regulatory requirements. SQL Server 2008 can also define a database review of each specification, so the review can be configured for each individual to develop a database. Configured for the specified object for examination to review the implementation of better performance, configuration flexibility is also higher. (B) to ensure business continuity * Improved SQL Server 2008 database mirroring on SQL Server 2005, and provides a more reliable platform for enhanced database mirroring. New features include: automatic page repair. SQL Server 2008 image by requesting cooperation from the machine to get a error page get re-copied, so the principal and mirror computers repair data transparently on the page 823 and 824 errors. * Improved performance. SQL Server 2008 compresses the output of the log stream in order to enable database mirroring the required network bandwidth to a minimum. Analysis of SQL Server sql server 2000 server is installed the previous version, for example, there is generally no more than one version 7.0, only the Standard Edition with the desktop version, users who do not know what version of the install, then proceed with the installation instructions on the installation of the installation prerequisites, general tops in the WIN2000 Server Edition Standard Edition, other systems can be installed on the desktop version; and SQL Server 2000 installation is relatively large, when the common problems are as follows: (1) configuration server interruption. (2) A registered ActiveX interrupted. (3) shows that 100% of the time interrupt. (4) Tip: command line option syntax error, type command /? for help, to continue the installation, in the end when you configure the server: can not find the specified dynamic link SQLUNIRL.DLL path ... ... (5) before the program creates a pending file operations, run the installation program, you must restart (1) (2) (3) solution: Reminder: To prevent this, back up your registry and the database can not enter the SQL Server 2000, you can backup Program Files Microsoft SQL Server MSSQL Data folder files. 1, first uninstall SQL Server (uninstall does not matter can not afford to continue to operate below) 2, the Microsoft SQL Server to delete the entire folder. 3, run the registry, delete the following key: HKEY_CURRENT_USER Software Microsoft Microsoft SQL Server HKEY_LOCAL_MACHINE SOFTWARE Microsoft Microsoft SQL Server HKEY_LOCAL_MACHINE SOFTWARE Microsoft MSSQLServer 4, necessary to restart the system 5, re-install It may also be try to single step method of installing SQL Server 2000: 1: Add SQL Server 2000 CD-ROM. 2: In the (F is the CD-ROM) Note: First, the different operating systems support SQL Server 2000 version and hardware requirements. Windows 2000 Server can be installed on any version of SQL Server 2000. Windows 2000 Professional can only install SQL Server 2000 Personal Edition, Developer Edition, Evaluation, MCDE Second, SQL Server 2000 versions and hardware requirements. (4) solution because the installation files (full path), there are Chinese. Such as c: SQLSERVER Chinese Enterprise Edition into c: SQLSERVER (5) the solution a, restart the machine, then install it If you find that there is this error, follow these steps b, at the beginning - the right window, right-click PendingFileRenameOperations, select Delete, and confirm f, restart the installation, problem solving -------------------------------- ----------------------- If the problem persists,
air force 1 high, try to repair the operating system before the implementation of the command prompt: sfc / scannow a last resort: for Windows 2000 installation SQL Server2000 installation disk drive and cause of the problem is very strange sometimes, someone had replaced a power supply to solve the problem. 1, uninstall your SQL Server 2000, when necessary, remove the Program Files Microsoft SQL Server folder 2 open registry in the HKEY_LOCAL_MACHINE + SOFTWART + Microsoft + Windows + CurrentVersion + Setup + ExceptionComponents 4 to ExceptionComponents delete all folders below! such as {60BFF50D-FB2C-4498-A577-C9548C390BB9} {60BFF50D-FB2C-4498-A577-C9548C390BB9} {60BFF50D-FB2C -4498-A577-C9548C390BB9} {60BFF50D-FB2C-4498-A577-C9548C390BB9} 6 restart: 7 to re-install SQL Server 2000 XP + SP2 problems 1.winxp + sp2 system need to install SQL Server SP3 (Service Pack 3 patch ), if previously installed, you must then install again. SP3 can be downloaded for free from Microsoft, the Chinese version of the address is as follows: SQL Server 2000 Service Pack 3a entries Atlas Atlas more extended reading: 1
http://cidian.sina.com.cn/cidian/browse. php? name = SqlServer
Open Category: database, server I have to perfect