SQL技术手册

章节摘录

插图：History of the SQL StandardIn response to the proliferation of SQL dialects,ANSI published its first SQL stan-dard in 1986 to bring about greater conformity among vendors.This was followedby a second,widely adopted standard in 1989.The International Standards Orga-nization （ISO）also approved the SQL standard.ANSI released one update in1992,known as SQL92 or SQL2,and another in 1999,termed SQL99 or SQL3.The next update,made in 2003,is also referred to as SQL3（or SQL2003）.Whenwe use that term in this book,we are referring to the 2003 revision of thestandard.Each time it revises the SQL standard,ANSI adds new features and incorporatesnew commands and capabilities into the language.For example,the SQL99 stan-dard added a group of capabilities that handled object-oriented datatypeextensions.What's New in SQL2006The ANSI standards body that regulates SQL issued a new standard in 2006,inwhich the important major improvements of SQL3 were retained and augmented.The ANSI SQL2006 release was evolutionary over the SQL3 release,but it did notinclude any significant changes to the SQL3 commands and functions that weredescribed in the second edition of this book.Instead,SQL2006 described anentirely new functional area of behavior for the SQL standard.Briefly,SQL2006describes how SQL and XML（the eXtensible Markup Language）interact.Forexample,the SQL2006 standard describes how to import and store XML data in aSQL database,manipulate that data,and then publish the data both in nativeXML form and as conventional SQL data wrapped in XML form.The SQL2006standard provides a means of integrating SQL application code with XQuery,theXML Query Language standardized by the World Wide Web Consortium（W3C）.Because XML and XQuery are disciplines in their own right,they are consideredbeyond the scope of this book and are not covered here.What's New in SQL2003（SQL3）SQL99 had two main parts,Foundation:1999 and Bindings:1999.The SQL3 Foun-dation section includes all of the Foundation and Bindings standards fromSQL99,as well as a new section called Schemata.The Core requirements of SQL3 did not change from Core SQL99,so the data-base platforms that conformed to Core SQL99 automatically conform to SQL3.Although the Core of SQI_3 has no additions（except for a few new reservedwords）,a number of individual statements and behaviors have been updated ormodified.Because these updates are reflected in the individual syntax descrip-tions of each statement in Chapter 3,we won't spend time on them here.

前言

Since its first incarnation in the 1970s,the Structured Query Language （SQL）hasbeen developed hand in hand with the information boom,and as a result,it is themost widely used database manipulation language in business and industry.Anumber of different software companies and program developers,including thosein the open source movement （http://www.opensource.org）,have concurrently developed their own SQL dialects in response to specific professional needs.Allthe while,standards bodies have developed a growing list of common features.SQL in a Nutshell,Third Edition,describes the latest ANSI standard,SQL2003（SQL3）version of each SQL command,and then documents each platform'simplementation of that command.In this book,you will find a concise explana-tion of the relational database management system （RDBMS）model,a clear-cutexplanation of foundational RDBMS concepts,and thorough coverage of SQLsyntax and commands.Most importantly,at least if you're a programmer or developer,SQL in a Nutshell,Third Edition,provides a concise guide both to the most popular commercialdatabase packages on the market （Microsoft SQL Server and Oracle）.It is also theguide for two of the best-known open source database products （MySQL andPostgreSQL）.The attention this book pays to open source SQL platforms recog-nizes the growing importance of the open source movement within the computingcommunity.

内容概要

Kevin E.Kline是Quest Software公司SQL Server Solution的负责人，该公司是数据库管理及应用程序监测工具的供应商。

书籍目录

Preface1.SQL History and Implementations　The Relational Model and ANSISQL　History of the SQL Standard　SQL Dialects2.Foundational Concepts　Database Platforms Described in This Book　Categories of Syntax　SQL2003 and Platform-Specific Datatypes　Constraints3.SQL Statement Command Reference　HowtoUseThisChapter　SQLPlatformSupport　SQLCommandReference4.SQL Functions　Types of Functions　ANSI SQL Aggregate Functions　ANSI SQL Window Functions　ANSI SQL Scalar Functions　Platform-Specific ExtensionsAppendix:Shared and Platform-Specific KeywordsIndex

编辑推荐

《SQL技术手册(影印版)》是由东南大学出版社出版发行的。

作者简介

《SQL技术手册》是当今最流行的数据库产品中使用的SQL语言的必不可少的一本指南。这个更新的版本依照最新的ANSI标准清楚地评述了每个SQL命令，并详述了这些命令在Microsoft SQL Server 2008、Oracle 11g、MySQL 5.1和PostgreSQL 8.3中分别如何实现。你还可以纵览关系数据库管理系统(RDBMS)模型，并获取关于RDBMS基本原理的明确解释。这本通俗易懂的书提供了：

·关系数据库模型的背景，包括当前的和以前的SQL标准

·用于理解关系数据库和SQL命令的必要基础原理

·按照SQL2003ANSI标准的按字母表顺序排列的SQL语句

·每一条命令的MySQL、Oracle、PostgreSQL和SQL Server实现

·按字母表顺序排列的ANSISQL2003函数和厂商实现

·每种实现独有的平台特定函数

《SQL技术手册》在厂商文档结束时就着手更新至第三版，提取了众多专业数据库管理者和开发者使用SQL支持复杂的企业级应用程序的不同经验。无论你是初学者还是已经使用了一段时间SQL，这本简明扼要且实用的书籍都会让你学习到许多技巧和技术。

图书封面

---

 SQL技术手册下载

---