Feb 29 | Leap years |
FETCH statement : syntax | FETCH statement [ESQL] [SP] |
fetches : blocking of | - r command-line option |
fetches : one row per request | - r command-line option |
File property | Properties available for each database |
FileDataSourceName connection parameter | FileDataSourceName connection parameter [FileDSN] |
files : dbspaces | CREATE DBSPACE statement |
files : location | How Adaptive Server Anywhere locates files |
FileVersion property | Properties available for each database |
FIPS : conformance | SQL_FLAGGER_ERROR_LEVEL option |
FIRE_TRIGGERS option | Transact-SQLcompatibility options FIRE_TRIGGERS option |
FIXED file format | INPUT_FORMAT option [ISQL OUTPUT_FORMAT option [ISQL |
float as double | FLOAT_AS_DOUBLE option |
FLOAT data type : about | FLOAT data type [Numeric] |
FLOAT_AS_DOUBLE option | FLOAT_AS_DOUBLE option |
FLOOR function | FLOOR function [Numeric] |
FOR statement : syntax | FOR statement |
foreign keys : and integrity | Adaptive Server Anywhere SQL features |
foreign keys : in the system tables | SYSFKCOL system table SYSFOREIGNKEY system table |
foreign keys : integrity constraints | CREATE TABLE statement |
foreign keys : role names | CREATE TABLE statement |
foreign keys : system views | SYSFOREIGNKEYS system view |
foreign keys : unnamed | CREATE TABLE statement |
foreign table : in the system tables | SYSFOREIGNKEY system table |
format : input file | INPUT_FORMAT option [ISQL |
FoxPro file format | INPUT_FORMAT option [ISQL OUTPUT_FORMAT option [ISQL |
FreeWriteCurr property | Properties available for the server |
FreeWritePush property | Properties available for the server |
FROM clause : SELECT statement | SELECT statement |
FROM clause : syntax | FROM clause |
FullCompare property | Connection properties Properties available for the server |
functions | CHAPTER 8. SQL Functions |
functions : ABS function | ABS function [Numeric] |
functions : ACOS function | ACOS function [Numeric] |
functions : aggregate | Aggregate functions |
functions : ARGN function | ARGN function [Miscellaneous] |
functions : ASCII function | ASCII function [String] |
functions : ASIN function | ASIN function [Numeric] |
functions : ATAN function | ATAN function [Numeric] |
functions : ATAN2 function | ATAN2 function [Numeric] |
functions : AVG function | AVG function [Aggregate] |
functions : BYTE_LENGTH function | BYTE_LENGTH function [String] |
functions : BYTE_SUBSTR function | BYTE_SUBSTR function [String] |
functions : CAST function | CAST function [Data type conversion] |
functions : CEILING function | CEILING function [Numeric] |
functions : CHAR function | CHAR function [String] |
functions : CHARINDEX function | CHARINDEX function [String] |
functions : CHAR_LENGTH function | CHAR_LENGTH function [String] |
functions : COALESCE function | COALESCE function [Miscellaneous] |
functions : col_length Adaptive Server Enterprise function | Connection properties |
functions : col_name Adaptive Server Enterprise function | Connection properties |
functions : CONNECTION_PROPERTY function | CONNECTION_PROPERTY function [System] |
functions : CONVERT function | CONVERT function [Data type conversion] |
functions : COS function | COS function [Numeric] |
functions : COT function | COT function [Numeric] |
functions : COUNT function | COUNT function [Aggregate] |
functions : creating | CREATE FUNCTION statement |
functions : curunreservedpgs Adaptive Server Enterprise function | Connection properties |
functions : data type conversion | Data type conversion functions |
functions : datalength Adaptive Server Enterprise function | Connection properties |
functions : DATALENGTH function | DATALENGTH function [System] DATALENGTH function [System] |
functions : data_pgs Adaptive Server Enterprise function | Connection properties |
functions : date and time | Date and time functions |
functions : DATE function | DATE function [Date and time] |
functions : DATEADD function | DATEADD function [Date and time-TSQL] |
functions : DATEDIFF function | DATEDIFF function [Date and time-TSQL] |
functions : DATEFORMAT function | DATEFORMAT function [Date and time] |
functions : DATENAME function | DATENAME function [Date and time-TSQL] |
functions : DATEPART function | DATEPART function [Date and time-TSQL] |
functions : DATETIME function | DATETIME function [Date and time] |
functions : DAY function | DAY function [Date and time] |
functions : DAYNAME function | DAYNAME function [Date and time] |
functions : DAYS function | DAYS function [Date and time] |
functions : db_id Adaptive Server Enterprise function | Connection properties |
functions : DB_ID function | DB_ID function [System] |
functions : db_name Adaptive Server Enterprise function | Connection properties |
functions : DB_NAME function | DB_NAME function [System] |
functions : DB_PROPERTY function | DB_PROPERTY function [System] |
functions : DEGREES function | DEGREES function [Numeric] |
functions : DIFFERENCE function | DIFFERENCE function [String] |
functions : DOW function | DOW function [Date and time] |
functions : dropping | DROP statement |
functions : ESTIMATE function | ESTIMATE function [Miscellaneous] |
functions : ESTIMATE_SOURCE function | ESTIMATE_SOURCE function [Miscellaneous] |
functions : EXP function | EXP function [Numeric] |
functions : EXPERIENCE_ESTIMATE function | EXPERIENCE_ESTIMATE function [Miscellaneous] |
functions : FLOOR function | FLOOR function [Numeric] |
functions : GETDATE function | GETDATE function [Date and time-TSQL] |
functions : HEXTOINT function | HEXTOINT function [Data type conversion] |
functions : host_id Adaptive Server Enterprise function | Connection properties |
functions : host_name Adaptive Server Enterprise function | Connection properties |
functions : HOUR function | HOUR function [Date and time] |
functions : HOURS function | HOURS function [Date and time] |
functions : IFNULL function | IFNULL function [Miscellaneous] |
functions : image | Text and image functions |
functions : index_col Adaptive Server Enterprise function | Connection properties |
functions : INDEX_ESTIMATE function | INDEX_ESTIMATE function [Miscellaneous] |
functions : INSERTSTR function | INSERTSTR function [String] |
functions : INTTOHEX function | INTTOHEX function [Data type conversion] |
functions : ISNULL function | ISNULL function [Miscellaneous] |
functions : LCASE function | LCASE function [String] |
functions : lct_admin Adaptive Server Enterprise function | Connection properties |
functions : LEFT function | LEFT function [String] |
functions : LENGTH function | LENGTH function[String] |
functions : LIST function | LIST function [Aggregate] |
functions : LOCATE function | LOCATE function [String] |
functions : LOG function | LOG function [Numeric] |
functions : LOG10 function | LOG10 function [Numeric] |
functions : LOWER function | LOWER function [String] |
functions : LTRIM function | LTRIM function [String] |
functions : MAX function | MAX function [Aggregate] |
functions : MIN function | MIN function [Aggregate] |
functions : MINUTE function | MINUTE function [Date and time] |
functions : MINUTES function | MINUTES function [Date and time] |
functions : miscellaneous | Miscellaneous functions |
functions : MOD function | MOD function [Numeric] |
functions : MONTH function | MONTH function [Date and time] |
functions : MONTHNAME function | MONTHNAME function [Date and time] |
functions : MONTHS function | MONTHS function [Date and time] |
functions : NEXT_CONNECTION function | NEXT_CONNECTION function [System] |
functions : NEXT_DATABASE function | NEXT_DATABASE function [System] |
functions : NOW function | NOW function [Date and time] |
functions : NULLIF function | NULLIF function [Miscellaneous] |
functions : NUMBER function | NUMBER function [Miscellaneous] |
functions : numeric | Numeric functions |
functions : object_id Adaptive Server Enterprise function | Connection properties |
functions : object_name Adaptive Server Enterprise function | Connection properties |
functions : PATINDEX function | PATINDEX function [String] |
functions : PI function | PI function [Numeric] |
functions : PLAN function | PLAN function [Miscellaneous] |
functions : POWER function | POWER function [Numeric] |
functions : proc_role Adaptive Server Enterprise function | Connection properties |
functions : PROPERTY function | PROPERTY function [System] |
functions : PROPERTY_DESCRIPTION function | PROPERTY_DESCRIPTION function [System] |
functions : PROPERTY_NAME function | PROPERTY_NAME function [System] |
functions : PROPERTY_NUMBER function | PROPERTY_NUMBER function [System] |
functions : QUARTER function | QUARTER function [Date and time] |
functions : RADIANS function | RADIANS function [Numeric] |
functions : RAND function | RAND function [Numeric] |
functions : REMAINDER function | REMAINDER function [Numeric] |
functions : REPEAT function | REPEAT function [String] |
functions : REPLICATE function | REPLICATE function [String] |
functions : reserved_pgs Adaptive Server Enterprise function | Connection properties |
functions : RIGHT function | RIGHT function [String] |
functions : ROUND function | ROUND function [Numeric] |
functions : rowcnt Adaptive Server Enterprise function | Connection properties |
functions : RTRIM function | RTRIM function [String] |
functions : SECOND function | SECOND function [Date and time] |
functions : SECONDS function | SECONDS function [Date and time] |
functions : show_role Adaptive Server Enterprise function | Connection properties |
functions : SIGN function | SIGN function [Numeric] |
functions : SIMILAR function | SIMILAR function [String] |
functions : SIN function | SIN function [Numeric] |
functions : SOUNDEX function | SOUNDEX function [String] |
functions : SPACE function | SPACE function [Miscellaneous] |
functions : SQRT function | SQRT function [Miscellaneous] |
functions : STR function | STR function [String] |
functions : string | String functions |
functions : STRING function | STRING function [String] |
functions : STUFF function | STUFF function [String] |
functions : SUBSTR function | SUBSTR function [String] |
functions : SUM function | SUM function [Aggregate] |
functions : suser_id Adaptive Server Enterprise function | Connection properties |
functions : suser_name Adaptive Server Enterprise function | Connection properties |
functions : system | Connection properties |
functions : TAN function | TAN function [Numeric] |
functions : text | Text and image functions |
functions : TEXTPTR function | TEXTPTR function [String] |
functions : TODAY function | TODAY function [Date and time] |
functions : TRACEBACK function | TRACEBACK function [Miscellaneous] |
functions : Transact-SQL | Connection properties |
functions : TRIM function | TRIM function [String] |
functions : TRUNCATE function | "TRUNCATE" function [Numeric] |
functions : TRUNCNUM function | TRUNCNUM function [Numeric] |
functions : tsequal Adaptive Server Enterprise function | Connection properties |
functions : UCASE function | UCASE function [String] |
functions : UPPER function | UPPER function [String] |
functions : used_pgs Adaptive Server Enterprise function | Connection properties |
functions : user-defined | CREATE FUNCTION statement RETURN statement |
functions : user_id Adaptive Server Enterprise function | Connection properties |
functions : user_name Adaptive Server Enterprise function | Connection properties |
functions : valid_name Adaptive Server Enterprise function | Connection properties |
functions : valid_user Adaptive Server Enterprise function | Connection properties |
functions : WEEKS function | WEEKS function [Date and time] |
functions : YEARS function | YEARS function [Date and time] |
functions : YMD function | YMD function [Date and time] |
functions system | System functions |
functions, numeric : ATAN | ATAN function [Numeric] |