SQL: 1999: Understanding Relational Language ComponentsMorgan Kaufmann, 2002 - Počet stran: 895 SQL: 1999 is the best way to make the leap from SQL-92 to SQL:1999, but it is much more than just a simple bridge between the two. The latest from celebrated SQL experts Jim Melton and Alan Simon, SQL:1999 is a comprehensive, eminently practical account of SQL's latest incarnation and a potent distillation of the details required to put it to work. Written to accommodate both novice and experienced SQL users, SQL:1999 focuses on the language's capabilities, from the basic to the advanced, and the ways that real applications take advantage of them. Throughout, the authors illustrate features and techniques with clear and often entertaining references to their own custom database.
|
Obsah
Preface | xxvii |
Database and Technology Foundations | 3 |
Introduction to SQL1999 | 25 |
Basic Table Creation and Data Manipulation | 61 |
Basic Data Definition Language DDL | 85 |
Values Basic Functions and Expressions | 115 |
Advanced Value Expressions CASE CAST and Row Value Expressions | 167 |
Predicates | 181 |
Connections and Remote Database Access | 535 |
Routines and Routine Invocation Functions and Procedures | 543 |
Dynamic SQL | 571 |
CallLevel Interface CLI | 627 |
Diagnostics and Error Management | 685 |
Internationalization Aspects of SQL1999 | 703 |
Information Schema | 717 |
A Look to the Future | 743 |
Working with Multiple Tables The Relational Operators | 225 |
Advanced SQL Query Expressions | 267 |
Constraints Assertions and Referential Integrity | 357 |
Active Databases and Triggers | 397 |
Accessing SQL from the Real World | 413 |
Cursors | 449 |
Privileges Users and Security | 471 |
Transaction Management | 513 |
Designing SQL1999 Databases | 749 |
An SQL1999 Application Example | 759 |
The SQL1999 Annexes | 777 |
Relevant Standards Bodies | 819 |
Status Codes | 827 |
The SQL Standardization Process | 835 |
847 | |
Další vydání - Zobrazit všechny
SQL: 1999: Understanding Relational Language Components Jim Melton,Alan R. Simon Omezený náhled - 2002 |
SQL: 1999: Understanding Relational Language Components Jim Melton,Alan R. Simon Zobrazení fragmentů - 2002 |
SQL: 1999: Understanding Relational Language Components Jim Melton,Alan R. Simon Náhled není k dispozici. - 2002 |
Běžně se vyskytující výrazy a sousloví
actor_first_name actor_last_name application array authorization identifier base tables Chapter character set character string CHARACTER VARYING CHECK constraint clause COBOL collation column name constant SQLSTATE_TYPE constraint contains CREATE TABLE current_dvd_sale_price cursor Data Definition Language data type database system datetime DBMS declaration default defined definition DELETE descriptor area diagnostics area discussed dynamic parameters dynamic SQL embedded SQL execute external routine FOREIGN KEY function grouping host language host variable implementation implementation-defined implementation-dependent INTEGER invoked length module movie titles movie_titles movie_type movies_stars music_titles null value operations OUTER JOIN predicate PRIMARY KEY privileges procedure query expression recursive reference referential referential integrity regular expression result set retrieve role name savepoint search condition SELECT statement specify SQL standard SQL statement SQL-invoked routines SQL's SQLCHAR SQLINTEGER SQLRETURN SQLSMALLINT SQLSTATE START TRANSACTION statement handle stored subquery Syntax table name temporary table tion transaction trigger user identifier value expression virtual table year_released