【正文】 ccess, adopted the standard SQL 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 mands can be used to plete almost all the database ServerSQL Server is a relational database management was originally proposed by Microsoft Sybase and AshtonT ate three panies jointly developed in 1988 with the introduction of the first OS / 2 the introduction of Windows NT in, Microsoft and Sybase in the development of SQL Server on the split,Microsoft will migrate to SQL Server on Windows NT system, focusing on promoting the development of SQL Server version of Windows is more focused on SQL Server in the UNIX operating system Server 2000 is Microsoft Launches the SQL Server data base management system, the inherited version of SQL Server version of the merits, at the same time it increases than many of the more advanced scalability with ease of use and related high degree of softwareintegration, across from the running Microsoft Windows 98 laptop running Microsoft Windows 2000 largescale multiprocessor servers such as the use of multiple Server 2005SQL Server 2005 is a prehensive database platform, the use of integrated business intelligence(BI)tools to provide enterpriseclass data Server 2005 relational database engine for data and structured data to provide a more secure and reliable storage function that allows you to build and manage high availability for business an d highperformance data Server 2005 data engine is the enterprise data management solutions for the SQL Server 2005 bines the analysis, reporting, integration and makes your business can build and deploy costeffective BI solutions that help your team through the Scorecard, Dashboard, Web services and data applications to mobile devices to all areas of Microsoft Visual Studio, Microsoft Office System and the new development kit(including the Business Intelligence Development Studio)to enable the close integration of SQL Server 2005 you39。re a developer , database administrator , information worker or decisionmakers, SQL Server 2005 that can provide you with innovative solutions to help you benefit from more SQL Server 2008SQL Server 2008 is a major product version, it introduced many new features and Key improvements made to date it has bee the strongest and most prehensive version of SQL article described in detail in Microsoft SQL Server 200839。s data platform to meet these data explosion and the next generation of data –driven applications that demand and support the data platform vision: missioncritical enterprise data platform, dynamic development, relational data andbusiness data platform vision SQL Server39。s digital information in the rapid growth of the with the norms and requirements of the development of globalization, the security of information storage and are available at any the same time, the cost of disk storage significantly reduced so that every dollar invested can store more to move quickly in a large amount of data to find relevant addition, on any device they want to use this information, and plan to use every day , such as the Microsoft Office system explosion of data and user expectations for an increase in the management of the pany has created many ? data platform vision to provide a solution to meet these needs, this solution is panies can store and manage the use of many data types, including XML, , time /calendar , files, documents, geographic, etc., at the same time provide a rich set of services to interact with the data: search, query , data analysis, reporting, data integration, synchronization and can access from the creation to archive to any device, from desktop to mobile devices The platform has the following characteristics:Trustedallows the pany to reduce development and management of their data infrastructure of the time and a prehensive platform for users in your time of need to send him to observe and trusted(A)the protection of your informationIn the past the basis of SQL Server 2005 on, SQL Server 2008 made the following enhancements to expand its security: * Simple data encryptionSQL Server 2008 can be the entire database, data files and log files for encryption, without requiring changes to enable panies to meet pliance with the norms and their concern about data privacy and the benefits of data encryption including the use of any scope or ambiguous search query data encryption to enhance data security to prevent unauthorized user access, as well as data can change the applications have been conducted.* Foreign key managementSQL Server 2008 for the encryption and key management provides a prehensive order to meet evolving data center for more information on the needs of security , to the supplier39。SQL 語言的主要功能就是同各種數(shù)據(jù)庫建立聯(lián)系，進(jìn)行溝通。SQL 語句可以用來執(zhí)行各種各樣的操作，例如更新數(shù)據(jù)庫中的數(shù)據(jù)，從數(shù)據(jù)庫中提取數(shù)據(jù)等。雖然很多數(shù)據(jù)庫都對 SQL 語句進(jìn)行了再開發(fā)和擴(kuò)展，但是包括 Select, Insert, Update, Delete, Create,以及Drop 在內(nèi)的標(biāo)準(zhǔn)的 SQL 命令仍然可以被用來完成幾乎所有的數(shù)據(jù)庫操作。它最初是由Microsoft Sybase和 AshtonTate三家公司共同開發(fā)的,于1988年推出了第一個OS/2版本。Sybase則較專注于SQL Server在UNIX操作系統(tǒng)上的應(yīng)用。SQL Server 2005 SQL Server 2005是一個全面的數(shù)據(jù)庫平臺，使用集成的商業(yè)智能(BI)工具提供了企業(yè)級的數(shù)據(jù)管理。SQLServer2005數(shù)據(jù)引擎是本企業(yè)數(shù)據(jù)管理解決方案的核心。這使您的企業(yè)可以構(gòu)建和部署經(jīng)濟(jì)有效的BI解決方案，幫助您的團(tuán)隊通過記分卡、Dashboard、Web services和移動設(shè)備將數(shù)據(jù)應(yīng)用推向業(yè)務(wù)的各個領(lǐng)域。無論您是開發(fā)人員、數(shù)據(jù)庫管理員、信息工作者還是決策者，SQLServer2005都可以為您提供創(chuàng)新的解決方案，幫助您從數(shù)據(jù)中更多地獲益。Server 2008 中的新的特性、優(yōu)點(diǎn)和功能……微軟的這個數(shù)據(jù)平臺滿足這些數(shù)據(jù)爆炸和下一代數(shù)據(jù)驅(qū)動應(yīng)用程序的需求，支持?jǐn)?shù)據(jù)平臺愿景：關(guān)鍵任務(wù)企業(yè)數(shù)據(jù)平臺、動態(tài)開發(fā)、關(guān)系數(shù)據(jù)和商業(yè)智能。遵守規(guī)范和全球化的發(fā)展要求信息存儲的安全性和在任何時候都可用。用戶必須快速的在大量的數(shù)據(jù)中找到相關(guān)的信息。對數(shù)據(jù)爆炸和用戶期望值的增加的管理為公司制造了許多挑戰(zhàn)。用戶可以訪問從創(chuàng)建到存檔于任何設(shè)備的信息，從桌面到移動設(shè)備的信息這個平臺有以下特點(diǎn)：一、可信任的（一）保護(hù)你的信息在過去的SQL Server 2005的基礎(chǔ)之上，SQL Server 2008做了以下方面的增強(qiáng)來擴(kuò)展它的安全性：* 簡單的數(shù)據(jù)加密SQL Server 2008可以對整個數(shù)據(jù)庫、數(shù)據(jù)文件和日志文件進(jìn)行加密，而不需要改動應(yīng)用程序。簡單的數(shù)據(jù)加密的好處包括使用任何范圍或模糊查詢搜索加密的數(shù)據(jù)、加強(qiáng)數(shù)據(jù)安全性以防止未授權(quán)的用戶訪問、還有數(shù)據(jù)加密。* 外鍵管理SQL Server 2008為加密和密鑰管理提供了一個全面的解決方案。SQL Server 2008 通過支持第三方密鑰管理和硬件安全模塊(HSM)產(chǎn)品為這個需求提供了很好的支持。審查不只包括對數(shù)據(jù)修改的所有信息，還包括關(guān)于什么時候?qū)?shù)據(jù)進(jìn)行讀取的信息。SQL Server 2008還可以定義每一個數(shù)據(jù)庫的審查規(guī)范，所以審查