| [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) |