Нашли опечатку? Выделите ее мышкой и нажмите Ctrl+Enter
Название: SQL in a Nutshell
Автор: Kline K.E.
Аннотация:
This essential desktop reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It includes the command syntax (by vendor, if the syntax differs across implementations), a description, and practical examples. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format.
column-level constraints Columns column_constraint_clause column_constraint_clause (Oracle) column_name COL_LENGTH COL_LENGTH function (SQL Server) COL_NAME COL_NAME function (SQL Server) comment COMMENT ANY TABLE COMMIT statement COMMIT TO SWITCHOVER TO committing committing transactions common vendor syntax Compact Compare COMPARE function compared to SQL Server compared to Sybase adaptive server Comparison operators2nd comparison operators and compile compiler_directives2nd COMPOSE COMPOSE function (Oracle) compress COMPRESS function (MySQL) COMPRESS SYSTEM DEFAULT compressed tables compressed tables in Oracle COMPUTE COMPUTE clause concat CONCAT function Concatenation operator CONCAT_NULL_YIELDS_NULL CONCAT_WS CONCAT_WS function (MySQL) conditional multitable CONNECT statement connecting using JDBC connection string attributes for connections (database) CONNECTION_ID( ) CONNECTION_ID( ) function (MySQL) connectivity, establishing Constraint Constraints constraint_state clause constraint_type CONTAINS CONTAINS function CONTAINS SQL CONTAINSTABLE CONTAINSTABLE function context CONTINUE CONTROL ON INDEX CONTROLFILE REUSE conv CONV function (MySQL) CONVERT CONVERT function CONVERT TO SUBSTITUTABLE copy_options CORR2nd CORR function2nd correlated correlated subqueries Correlated subquery in WHERE/HAVING clause CORR_K CORR_K function (Oracle) cos cos function cosh COSH function cot COT function COUNT2nd COUNT function2nd COUNT_BIG COUNT_BIG function COVAR_POP2nd COVAR_POP function2nd COVAR_SAMP2nd COVAR_SAMP function2nd create CREATE ANY TABLE CREATE CLUSTER CREATE DATABASE LINK CREATE DATAFILE CREATE DIMENSION CREATE INDEX syntax CREATE INDEXTYPE CREATE MATERIALIZED VIEW CREATE OPERATOR CREATE PROCEDURE CREATE PUBLIC DATABASE LINK CREATE ROLE CREATE SEQUENCE CREATE SESSION CREATE SNAPSHOT CREATE STANDBY CONTROLFILE AS CREATE SYNONYM CREATE TRIGGER CREATE TYPE CREATE USER CREATE VIEW CREATE {DATABASE | DB} CREATE/ALTER DATABASE statements CREATE/ALTER DOMAIN statements, quick reference CREATE/ALTER FUNCTION/PROCEDURE statements CREATE/ALTER INDEX statements CREATE/ALTER METHOD statements CREATE/ALTER ROLE statements CREATE/ALTER SCHEMA statements CREATE/ALTER TABLE CREATE/ALTER TABLE statements CREATE/ALTER TRIGGER statements CREATE/ALTER TYPE statements CREATE/ALTER VIEW statements Creating CROSS JOIN CUME_DIST2nd CUME_DIST function2nd 3rd CUME_DIST( ) CURDATE( ) CURDATE( ) function (MySQL) Currency parameter object type (ADO.NET) CURSOR datatype cursors[See CLOSE CURSOR statement DECLARE CURSOR command] CURSOR_CLOSE_ON_COMMIT CURSOR_DEFAULT CURTIME( ) CURTIME( ) function (MySQL) CV CV function (Oracle) DATA data capture2nd Data Control Language (DCL) Data Definition Language (DDL) DATA DIRECTORY Data manipulation language (DML) Data structures Database database connection database objects and operators2nd DATABASE PARTITION GROUP
database program example database programming[See programming databases] DATABASE( ) DATABASE( ) function (MySQL) DATABASEPROPERTYEX DATABASEPROPERTYEX function database_privileges DATAFILE2nd DATALENGTH DATALENGTH function (SQL Server) DATALINK datatype datalink-related attributes DataReader methods DataReader methods (ADO.NET) datatype Datatypes date date datatype DATE function (DB2) DATEADD DATEADD function (SQL Server) DateDiff DATEDIFF function (SQL Server) DATENAME DATENAME function (SQL Server) DatePart DATEPART function (SQL Server) dateTime datatype DateTime parameter object type (ADO.NET) DATE_ FORMAT DATE_ FORMAT function (MySQL) DATE_ADD DATE_ADD function (MySQL) DATE_PART DATE_PART function (PostgreSQL) DATE_SUB DATE_SUB function (MySQL) DATE_TRUNC DATE_TRUNC function (PostgreSQL) Day Day function DAYNAME DAYNAME function DAYOFMONTH DAYOFMONTH function (MySQL) DAYOFWEEK DAYOFWEEK function DAYOFWEEK_ISO DAYOFWEEK_ISO function (DB2) DAYOFYEAR DAYOFYEAR function days DAYS function (DB2) DB2 DB2 keywords DB2 supported[See DB2functions] DB2 syntax DBCLOB DBCLOB datatype DBCLOB function (DB2) DBCREATOR DBCREATOR (SQL Server system role) DBINFO DBPARTITIONNUM DBPARTITIONNUM function (DB2) DBTIMEZONE DBTIMEZONE function (Oracle) db_accessadmin DB_ACCESSADMIN (SQL Server system role) db_backupoperator DB_BACKUPOPERATOR (SQL Server system role) db_datareader DB_DATAREADER (SQL Server system role) db_datawriter DB_DATAWRITER (SQL Server system role) db_ddladmin DB_DDLADMIN (SQL Server system role) db_denydatareader DB_DENYDATAREADER (SQL Server system role) db_denydatawriter DB_DENYDATAWRITER (SQL Server system role) DB_ID DB_ID function (SQL Server) DB_NAME DB_NAME function (SQL Server) db_owner DB_OWNER (SQL Server system role) db_securityadmin DB_SECURITYADMIN (SQL Server system role) DEALLOCATE UNUSED DEBUG DEBUG ANY PROCEDURE DEBUG CONNECT SESSION DEC DEC datatype DEC function (DB2) decimal decimal datatype DECIMAL function (DB2) Decimal parameter object type (ADO.NET) declarative processing DECLARE CURSOR command Decode DECODE function Decompose DECOMPOSE function (Oracle) DECRYPT_BIN DECRYPT_BIN function (DB2) DECRYPT_CHAR DECRYPT_CHAR function (DB2) defacto standard syntax default default database user accounts DEFAULT TABLESPACE DEFAULT TEMPORARY TABLESPACE DEFINITION ONLY DEGREES DEGREES function DELAY_KEY_WRITE DELETE ANY TABLE DELETE statement deleted elements in SQL2003 delimited identifiers delimiters delimiters and operators DENSE_RANK2nd DENSE_RANK function2nd 3rd DENSE_RANK( ) Depth DEPTH function (Oracle) DEREF DEREF function derived_table_options DESC description Deterministic Deterministic functions DFT_EXTENT_SZ dialects, SQL Diameter DIAMETER function (PostgreSQL) Difference Difference function DIGITS DIGITS function (DB2) DIMENSION Directory DISCONNECT statement diskadmin DISKADMIN (SQL Server system role)
|
|
О проекте