A Guide to SQL Standard

The SQL language has established itself as the linqua franca database management; it provides the basis for systems interoperability, application portability, client/server operation, distributed database, and more, and is supported by just about every DBMS on the market today. SQL2 - or, to give it its official name, the International Standard Database language SQL (1992) - represents a major set of extensions to the earlier SQL standard. For a start, the new specification is well over 600 pages, compared with less than 100 for the original version. No database professional can afford to ignore it. Features *Thorough revision of the official ANSI standard for SQL. *Covers all important new SQL2 features including extensive integrity support, powerful new operators, national and international character data support and comprehensive date and time support. *Continues the tradition of careful, clear, and accurate explanations of complex technical material Features New to this Edition *Covers extensive integrity support, powerful new operators, national and international character data support, all features of SQL2; comprehensive date and time support and clear explanation of the complexitites of Dynamic SQL, all features of SQL2. *Provides first tutorial treatment available anywhere of the brand new and dramatically extended version of SQL known informally as SQL2 or SQL/92. 0201964260B04062001