Table of Contents

[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] sampling SAVEPOINT statement      DB2      keywords      MySQL      Oracle      platform support for      PostgreSQL      programming tips      quick reference      rules      SQL Server      SQL2003 syntax scalar functions 2nd      built-in      categories of scalar subqueries Scalar subquey in SELECT item list Scalar subquey in WHERE/HAVING clause schema addressing schemas SCN_TO_TIMESTAMP function (Oracle) SEC_TO_TIME function (MySQL) SECOND function      DB2      MySQL SECURITYADMIN (SQL Server system role) SELECT statement      DB2      examples      GROUP BY clause      HAVING clause      keywords          ALL          AS          DISTINCT          FROM          GROUP BY          HAVING          JOIN          ORDER BY          WHERE      MySQL      operators and 2nd      Oracle      ORDER BY clause      platform support for      PostgreSQL      programming tips      quick reference      rules      SQL Server      SQL2003 syntax SEQUEL (Structured English Query Language) SERIAL datatype      platform comparison      PostgreSQL SERIAL4 datatype      platform comparison      PostgreSQL SERIAL8 datatype      platform comparison      PostgreSQL Serializable isolation level (Transaction object (ADO.NET)) SERVERADMIN (SQL Server system role) SESSION_USER function SESSION_USER( ) function (MySQL) SESSIONTIMEZONE function (Oracle) SET CATALOG statement, quick reference SET COLLATION statement, quick reference SET CONNECTION statement      DB2      description      keywords      MySQL      Oracle      platform support for      PostgreSQL      programming tips      quick reference      rules      SQL Server      SQL2003 syntax SET CONSTRAINT statement      DB2      keywords      MySQL      Oracle      platform support for      PostgreSQL      programming tips      quick reference      rules      SQL Server      SQL2003 syntax SET datatype      MySQL      platform comparison SET DESCRIPTOR statement, quick reference SET function (Oracle) set methods (JDBC PreparedStatement) set operations SET PATH statement      DB2      keywords      MySQL      Oracle      platform support for      PostgreSQL      programming tips      rules      SQL Server      SQL2003 syntax SET ROLE statement      DB2      keywords      MySQL      Oracle      platform support for      PostgreSQL      programming tips      rules      SQL Server      SQL2003 syntax SET SCHEMA statement      DB2      keywords      MySQL      Oracle      platform support for      PostgreSQL      programming tips      rules      SQL Server      SQL2003 syntax SET SESSION AUTHORIZATION statement      DB2      keywords      MySQL      Oracle      platform support for      PostgreSQL      programming tips      rules      SQL Server      SQL2003 syntax SET statement      DB2      keywords      MySQL      Oracle      platform support for      PostgreSQL      programming tips      quick reference      rules      SQL Server      SQL2003 syntax SET TIME ZONE statement      DB2      keywords      MySQL      Oracle      platform support for      PostgreSQL      programming tips      rules      SQL Server      SQL2003 syntax SET TRANSACTION statement      DB2      keywords      MySQL      Oracle      platform support for      PostgreSQL      programming tips      rules      SQL Server      SQL2003 syntax SET_MASKLEN function (PostgreSQL) SETUPADMIN (SQL Server system role) SHA function (MySQL) SHA1 function (MySQL) shared keywords SHOW_ROLE( ) function SHOW_SEC_SERVICES( ) function SIGN function      DB2      MySQL      Oracle      SQL Server SIN function      DB2      MySQL      Oracle      PostgreSQL      SQL Server Single parameter object type (ADO.NET) SINH function      DB2      Oracle SMALLDATETIME datatype      platform comparison      SQL Server 2nd      Sybase adaptive server SMALLINT datatype      DB2      MySQL      Oracle      platform comparison      PostgreSQL      SQL Server SMALLINT function (DB2) SMALLMONEY datatype      platform comparison      SQL Server SOME operator 2nd      keywords      platform differences      platform support for      programming tips      quick reference      rules      SQL2003 syntax SORTKEY function SOUNDEX function      DB2      MySQL      Oracle      SQL Server SPACE function      DB2      MySQL      SQL Server SQL command reference, quick reference SQL dialects SQL history and implementations SQL Server      allowed characters in identifiers      basics      beginning identifier character      BIGINT datatype      BINARY datatype      CALL statement      CHAR( ) datatype      CLOSE CURSOR statement      COMMIT statement      CONNECT statement      connecting using JDBC      CREATE/ALTER DATABASE statements          ADD FILEGROUP          ADD LOG          ANSI_NULL_DEFAULT          ANSI_NULLS          ANSI_PADDING          ANSI_WARNINGS          ARITHABORT          AUTO_CLOSE          AUTO_CREATE_STATISTICS          auto_option          AUTO_SHRINK          AUTO_UPDATE_STATISTICS          COLLATE          CONCAT_NULL_YIELDS_NULL          CURSOR_CLOSE_ON_COMMIT          CURSOR_DEFAULT          FOR LOAD          MODIFY FILE          MODIFY FILEGROUP          MODIFY NAME          MULTI_USER          NUMERIC_ROUNDABORT          OFFLINE          ON file_definition          QUOTED_IDENTIFIER          READ_ONLY          RECOVERY          RECURSIVE_TRIGGERS          REMOVE FILE          REMOVE FILEGROUP          RESTRICTED_USER          SET          SINGLE_USER          sql_options clause          TORN_PAGE_DETECTION          WITH      CREATE/ALTER FUNCTION/PROCEDURE statements          @parameter datatype          CREATE          ENCRYPTION          FOR REPLICATION          RECOMPILE          RETURNS          SCHEMABINDING          WITH      CREATE/ALTER INDEX statements          ASC          CLUSTERED          DESC          DROP_EXISTING          FILLFACTOR          IGNORE_DUP_KEY          ON          PAD_INDEX          SORT_IN_TEMPDB          STATISTICS_NORECOMPUTE          WITH      CREATE/ALTER METHOD statements      CREATE/ALTER ROLE statements      CREATE/ALTER SCHEMA statements      CREATE/ALTER TABLE statements          CHECK          CHECK CONSTRAINT          COLLATE          DEFAULT          ENABLE TRIGGER          FOREIGN KEY          IDENTITY          NOT FOR REPLICATION          PRIMARY KEY          ROWGUIDCOL          TEXTIMAGE_ON          WITH CHECK      CREATE/ALTER TRIGGER statements      CREATE/ALTER TYPE statements      CREATE/ALTER VIEW statements      datatypes          compared to Sybase adaptive server      DATETIME datatype      DECLARE CURSOR command          DYNAMIC          FAST_FORWARD          FOR          FOR UPDATE          FORWARD_ONLY          GLOBAL          INSENSITIVE          KEYSET          LOCAL          OPTIMISTIC          READ_ONLY          SCROLL          SCROLL_LOCKS          SQL-92 compatibility syntax          STATIC          Transact-SQL extensioned syntax          TYPE_WARNING      DELETE statement      delimiters and operators      DISCONNECT statement      DROP statements          DATABASE          DEFAULT          FUNCTION          INDEX          PROCEDURE          RULE          STATISTICS          TABLE          TRIGGER          TYPE          VIEW      EXCEPT set operator      FETCH statement      functions          ACOS          APP_NAME          ASCII          ASIN          ATAN          ATN2          BINARY_CHECKSUM          CHAR          CHARINDEX          CHECKSUM          CHECKSUM_AGG          COALESCE          COL_LENGTH          COL_NAME          CONTAINS          CONTAINSTABLE          CONVERT          COS          COT          DATABASEPROPERTYEX          DATALENGTH          DATEADD          DATEDIFF          DATENAME          DATEPART          DAY          DB_ID          DB_NAME          DEGREES          DIFFERENCE          FILE_ID          FILE_NAME          FILEGROUP_ID          FILEGROUP_NAME          FILEPROPERTY          FORMATMESSAGE          FREETEXT          FREETEXTTABLE          FULLTEXTCATALOGPROPERTY          FULLTEXTSERVICEPROPERTY          GETANSINULL          GETDATE( )          GETUTCDATE( )          GROUPING          HOST_ID( )          HOST_NAME( )          IDENT_CURRENT          IDENT_INCR          IDENT_SEED          IDENTITY          INDEX_COL          INDEXPROPERTY          IS_MEMBER          IS_SRVROLEMEMBER          ISDATE          ISNULL          ISNUMERIC          LEFT          LEN          LOG          LOG10          LTRIM          MONTH          NCHAR          NEWID( )          NULLIF          OBJECT_ID          OBJECT_NAME          OBJECTPROPERTY          OPEN          OPENDATASOURCE          OPENQUERY          OPENROWSET          PARSENAME          PATINDEX          PERMISSIONS          PI( )          RADIANS          RAND          REPLACE          REPLICATE          REVERSE          RIGHT          ROUND          ROWCOUNT_BIG          RTRIM          SIGN          SIN          SOUNDEX          SPACE          STATS_DATE          STDEV          STDEVP          STR          STUFF          SUBSTRING          SUSER_ID          SUSER_SID          SUSER_SNAME          TAN          TEXTPTR          TEXTVALID          TYPEPROPERTY          UNICODE          USER_ID          USER_NAME          VAR          VARP          YEAR      GRANT statement      identifier size      INSERT statement      INTERSECT set operator      JOIN subclause      keywords      LIKE operator      MERGE statement      NCHAR( ) datatype 2nd      nested triggers      NTEXT datatype      OPEN statement      ORDER BY clause      recursive triggers      RELEASE SAVEPOINT statement      reserved identifiers      RETURN statement      REVOKE statement      ROLLBACK statement      ROWVERSION datatype      SAVEPOINT statement      schema addressing      SELECT statement          COMPUTE clause          FOR          FROM          GROUP BY          INTO          OPTION          ORDER BY          TOP      SET CONNECTION statement      SET CONSTRAINT statement      SET PATH statement      SET ROLE statement      SET SCHEMA statement      SET SESSION AUTHORIZATION statement      SET statement      SET TIME ZONE statement      SET TRANSACTION statement      SMALLDATETIME datatype      SQL_VARIANT datatype      START TRANSACTION statement      stored procedures 2nd      SUBQUERY substatement      system roles          BULKADMIN          DB_ACCESSADMIN          DB_BACKUPOPERATOR          DB_DATAREADER          DB_DATAWRITER          DB_DDLADMIN          DB_DENYDATAREADER          DB_DENYDATAWRITER          DB_OWNER          DB_SECURITYADMIN          DBCREATOR          DISKADMIN          PROCESSADMIN          SECURITYADMIN          SERVERADMIN          SETUPADMIN          SYSADMIN      TRUNCATE TABLE statement      UDFs      UNION set operator      UNIQUEIDENTIFIER datatype      UPDATE statement      VARBINARY( ) datatype      VARCHAR( ) datatype      versus Sybase adaptive server          functions      web site      WHERE clause SQL Standard web site SQL/CLI (Call-Level Interface) SQL/Foundation SQL/Framework SQL/JRT (Java Routines and Types) SQL/MED (Management of External Data) SQL/OBJ (Object Language Binding) SQL/PSM (Persistent Stored Modules) SQL/Schemata SQL/XML 2nd SQL_VARIANT datatype      platform comparison      SQL Server 2nd SQL2003      allowed characters in identifiers      beginning identifier character      categories and datatypes      data structures      identifier size      keywords      new features      numeric functions      reserved identifiers      schema addressing      statement classes      supplemental features packages      window syntax SQL2003 keywords SQL2003 syntax      ALL operator      ANY operator      BETWEEN operator      CALL statement      CLOSE CURSOR statement      COMMIT statement      CONNECT statement      CREATE/ALTER FUNCTION/PROCEDURE statements      CREATE/ALTER METHOD statements      CREATE/ALTER ROLE statements      CREATE/ALTER SCHEMA statements      CREATE/ALTER TABLE statements      CREATE/ALTER TRIGGER statements      CREATE/ALTER TYPE statements      CREATE/ALTER VIEW statements      DECLARE CURSOR command      DELETE statement      DISCONNECT statement      DROP statements      EXCEPT set operator      EXISTS operator      FETCH statement      GRANT statement      IN operator      INSERT statement      INTERSECT set operator      IS operator      JOIN subclause      LIKE operator      MERGE statement      OPEN statement      ORDER BY clause      RELEASE SAVEPOINT statement      RETURN statement      REVOKE statement      ROLLBACK statement      SAVEPOINT statement      SELECT statement      SET CONNECTION statement      SET CONSTRAINT statement      SET PATH statement      SET ROLE statement      SET SCHEMA statement      SET SESSION AUTHORIZATION statement      SET statement      SET TIME ZONE statement      SET TRANSACTION statement      SOME operator      START TRANSACTION statement      SUBQUERY substatement      UNION set operator      UPDATE statement      WHERE clause SQL92 SQL99      deleted elements in SQL2003 SqlConnection      connection string attributes for SQLPL SQRT function standby databases (Oracle) START TRANSACTION statement      DB2      MySQL      Oracle      platform support for      PostgreSQL      programming tips      rules      SQL Server      SQL2003 syntax statement objects      associating SQL with      creating      executing statements      executing      preparing and executing      re-executing      Sybase adaptive server SQL STATS_BINOMIAL_TEST function (Oracle) STATS_DATE function      SQL Server STD function (MySQL) STDDEV function      DB2      MySQL      Oracle STDDEV_POP function 2nd STDDEV_SAMP function 2nd      Oracle STDEV function      SQL Server STDEV_POP function (Oracle) STDEVP function      SQL Server STOP LOGICAL STANDBY APPLY storage_clause (Oracle) stored procedures      operators and 2nd STR function (SQL Server) STRCMP function (MySQL) string functions and operators String parameter object type (ADO.NET) StringFixedLength parameter object type (ADO.NET) STUFF function (SQL Server) SUBDATE function (MySQL) subpartitioned tables      Oracle          altering subqueries      correlated      nested table      scalar      table SUBQUERY substatement      DB2      examples      keywords      MySQL      Oracle      platform support for 2nd      PostgreSQL      programming tips      rules      SQL Server      SQL2003 syntax SUBSTR function      DB2      Oracle      PostgreSQL SUBSTRB function (Oracle) SUBSTRING function      MySQL      PostgreSQL      SQL Server SUBSTRING_INDEX function (MySQL) subtraction (-) arithmetic operator suffixes SUM function 2nd SUSER_ID function      SQL Server SUSER_NAME function SUSER_SID function      SQL Server SUSER_SNAME function      SQL Server SYB_SENDMSG function Sybase Adaptive Aerver      TIMESTAMP datatype Sybase Adaptive Server      BINARY datatype      CHAR( ) datatype      datatypes          compared to SQL Server      DATETIME datatype      keywords 2nd      NCHAR( ) datatype      NVARACHAR( ) datatype      SMALLDATETIME datatype      SQL statements      statements      supported functions      UNICHAR datatype      UNIVARCHAR datatype      VARBINARY( ) datatype      VARCHAR( ) datatype      versus SQL Server          functions Sybase Adaptive Server keywords Sybase adaptive server keywords SYS_CONNECT_BY_PATH function (Oracle) SYS_CONTEXT function (Oracle) SYS_DBURIGEN function (Oracle) SYS_EXTRACT_UTC function (Oracle) SYS_GUID( ) function (Oracle) SYS_TYPEID function (Oracle) SYS_XMLAGG function (Oracle) SYS_XMLGEN function (Oracle) SYSADMIN (SQL Server system role) SYSDATE function (Oracle) SYSDATE( ) function (MySQL) system delimiters SYSTEM_USER function SYSTEM_USER( ) function (MySQL) SYSTIMESTAMP function (Oracle)

Table of Contents