SQL in a Nutshell (In a Nutshell (OReilly))

     
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y]

FETCH statement

        DB2

        keywords

        MySQL

        Oracle

        platform support for

        PostgreSQL

        programming tips

        quick reference

        rules

        SQL Server

        SQL2003 syntax

FIELD function (MySQL)

FILE_ID function

        SQL Server

FILE_NAME function

        SQL Server

FILEGROUP_ID function

        SQL Server

FILEGROUP_NAME function

        SQL Server

FILEGROUPPROPERTY function

        SQL Server

FILEPROPERTY function

        SQL Server

filtering checks

FIND_IN_SET function (MySQL)

FIRST function (Oracle)

FIRST_VALUE function (Oracle)

FLOAT datatype

        DB2

        MySQL

        Oracle

        platform comparison

        SQL Server 2nd

FLOAT function

        DB2

        PostgreSQL

FLOAT4 datatype

        platform comparison

        PostgreSQL

FLOAT4 function (PostgreSQL)

FLOAT8 datatype

        platform comparison

        PostgreSQL

FLOOR function

FOREIGN KEY constraints

        CASCADE keyword

        FOREIGN KEY keyword

        MATCH keyword

        NO ACTION keyword

        ON DELETE keyword

        ON UPDATE keyword

        REFERENCES keyword

        RESTRICT keyword

        SET DEFAULT keyword

        SET NULL keyword

FORMAT function (MySQL)

FORMATMESSAGE function

        SQL Server

freeing resources

FREETEXT function (SQL Server)

FREETEXTTABLE function

        SQL Server

FROM clause

FROM_DAYS function (MySQL)

FROM_TZ function (Oracle)

FROM_UNIXTIME function (MySQL) 2nd

FULL [OUTER] JOIN

FULLTEXTCATALOGPROPERTY function

        SQL Server

FULLTEXTSERVICEPROPERTY function

        SQL Server

functions

        ABS

        aggregate

        APP_NAME( )

        AVG 2nd

        BINARY_CHECKSUM

        BIT_LENGTH

        CASE

        CAST 2nd

        CEIL

        CHAR_LENGTH 2nd

        CHECKSUM

        CHECKSUM_AGG

        COALESCE

        COMPARE

        CONTAINS

        CONTAINSTABLE

        CONVERT

        CORR 2nd

        COUNT 2nd

        COUNT_BIG

        COVAR_POP 2nd

        COVAR_SAMP 2nd

        CUME_DIST 2nd

        CUME_DIST( )

        DATABASEPROPERTYEX

        DAY

        DB2 supported [See DB2, functions]

        DENSE_RANK 2nd

        DENSE_RANK( )

        deterministic

        EXP

        EXTRACT

        FILE_ID

        FILE_NAME

        FILEGROUP_ID

        FILEGROUP_NAME

        FILEGROUPPROPERTY

        FILEPROPERTY

        FLOOR

        FORMATMESSAGE

        FREETEXTTABLE

        FULLTEXTCATALOGPROPERTY

        FULLTEXTSERVICEPROPERTY

        GETANSINULL

        GETUTCDATE( )

        GROUPING

        HEXTOINT

        IDENT_CURRENT

        IDENT_INCR

        IDENT_SEED

        IDENTITY

        INDEXPROPERTY

        INTTOHEX

        IS_MEMBER

        IS_SEC_SERVICE_ON

        IS_SRVROLEMEMBER

        ISDATE

        ISNUMERIC

        lct_admin

        LEFT

        LEN

        LICENSE_ENABLED

        LN

        LOWER

        MAX 2nd

        MIN 2nd

        MOD

        MONTH

        MUT_EXCL_ROLES

        MySQL supported [See MySQL, functions]

        NCHAR

        NEWID( )

        nondeterministic

        NULLIF

        numeric

        OBJECTPROPERTY

        OCTET_LENGTH

        OPEN

        OPENDATASOURCE

        OPENQUERY

        OPENROWSET

        operators and 2nd

        Oracle supported [See Oracle, functions]

        OVERLAY

        PARSENAME

        PATINDEX

        PERCENT_RANK 2nd 3rd

        PERCENTILE_CONT 2nd

        PERCENTILE_DISC 2nd

        PERMISSIONS

        POSITION

        PostgreSQL [See PostgreSQL, functions]

        POWER

        PROC_ROLE

        RANK 2nd

        RANK( )

        REGR_AVGX 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

        REGR_AVGY 2nd 3rd 4th 5th 6th 7th 8th 9th

        REGR_COUNT 2nd 3rd 4th 5th 6th 7th 8th

        REGR_INTERCEPT 2nd 3rd 4th 5th 6th 7th

        REGR_R2 2nd 3rd 4th 5th 6th

        REGR_SLOPE 2nd 3rd 4th 5th

        REGR_SXX 2nd 3rd 4th

        REGR_SXY 2nd 3rd

        REGR_SYY 2nd

        REPLACE

        ROLE_CONTAIN

        ROLE_ID

        ROLE_NAME

        ROW_NUMBER

        ROWCNT

        ROWCOUNT_BIG( )

        scalar 2nd

                built-in

                categories of

        SESSION_USER

        SHOW_ROLE( )

        SHOW_SEC_SERVICES( )

        SORTKEY

        SQL Server supported [See SQL Server, functions]

        SQL2003 numeric

        SQRT

        STATS_DATE

        STDDEV_POP 2nd

        STDDEV_SAMP 2nd

        STDEV

        STDEVP

        string

        SUBSTRING

        SUM 2nd

        SUSER_ID

        SUSER_NAME

        SUSER_SID

        SUSER_SNAME

        SYB_SENDMSG

        Sybase adaptive server versus SQL Server

        Sybase adaptive server-supported

        SYSTEM_USER

        TO_UNICHAR

        TRANSLATE

        TRIM

        TSEQUEL

        TYPEPROPERTY

        types of

        UHIGHSURR

        ULOWSURR

        UNICODE

        UPPER

        USCALAR

        VALID_NAME

        VALID_USER

        VAR

        VAR_POP 2nd

        VAR_SAMP 2nd

        VARP

        WIDTH_BUCKET

        window 2nd

        windowing

        YEAR

 

Категории