📄 sqlext.h
字号:
#define SQL_DL_SQL92_INTERVAL_SECOND 0x00000100L
#define SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH 0x00000200L
#define SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR 0x00000400L
#define SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE 0x00000800L
#define SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND 0x00001000L
#define SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE 0x00002000L
#define SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND 0x00004000L
#define SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND 0x00008000L
/* SQL_CATALOG_LOCATION values */
#define SQL_CL_START SQL_QL_START
#define SQL_CL_END SQL_QL_END
/* values for SQL_BATCH_ROW_COUNT */
#define SQL_BRC_PROCEDURES 0x0000001
#define SQL_BRC_EXPLICIT 0x0000002
#define SQL_BRC_ROLLED_UP 0x0000004
/* bitmasks for SQL_BATCH_SUPPORT */
#define SQL_BS_SELECT_EXPLICIT 0x00000001L
#define SQL_BS_ROW_COUNT_EXPLICIT 0x00000002L
#define SQL_BS_SELECT_PROC 0x00000004L
#define SQL_BS_ROW_COUNT_PROC 0x00000008L
/* Values for SQL_PARAM_ARRAY_ROW_COUNTS getinfo */
#define SQL_PARC_BATCH 1
#define SQL_PARC_NO_BATCH 2
/* values for SQL_PARAM_ARRAY_SELECTS */
#define SQL_PAS_BATCH 1
#define SQL_PAS_NO_BATCH 2
#define SQL_PAS_NO_SELECT 3
/* Bitmasks for SQL_INDEX_KEYWORDS */
#define SQL_IK_NONE 0x00000000L
#define SQL_IK_ASC 0x00000001L
#define SQL_IK_DESC 0x00000002L
#define SQL_IK_ALL (SQL_IK_ASC | SQL_IK_DESC)
/* Bitmasks for SQL_INFO_SCHEMA_VIEWS */
#define SQL_ISV_ASSERTIONS 0x00000001L
#define SQL_ISV_CHARACTER_SETS 0x00000002L
#define SQL_ISV_CHECK_CONSTRAINTS 0x00000004L
#define SQL_ISV_COLLATIONS 0x00000008L
#define SQL_ISV_COLUMN_DOMAIN_USAGE 0x00000010L
#define SQL_ISV_COLUMN_PRIVILEGES 0x00000020L
#define SQL_ISV_COLUMNS 0x00000040L
#define SQL_ISV_CONSTRAINT_COLUMN_USAGE 0x00000080L
#define SQL_ISV_CONSTRAINT_TABLE_USAGE 0x00000100L
#define SQL_ISV_DOMAIN_CONSTRAINTS 0x00000200L
#define SQL_ISV_DOMAINS 0x00000400L
#define SQL_ISV_KEY_COLUMN_USAGE 0x00000800L
#define SQL_ISV_REFERENTIAL_CONSTRAINTS 0x00001000L
#define SQL_ISV_SCHEMATA 0x00002000L
#define SQL_ISV_SQL_LANGUAGES 0x00004000L
#define SQL_ISV_TABLE_CONSTRAINTS 0x00008000L
#define SQL_ISV_TABLE_PRIVILEGES 0x00010000L
#define SQL_ISV_TABLES 0x00020000L
#define SQL_ISV_TRANSLATIONS 0x00040000L
#define SQL_ISV_USAGE_PRIVILEGES 0x00080000L
#define SQL_ISV_VIEW_COLUMN_USAGE 0x00100000L
#define SQL_ISV_VIEW_TABLE_USAGE 0x00200000L
#define SQL_ISV_VIEWS 0x00400000L
/* Bitmasks for SQL_ASYNC_MODE */
#define SQL_AM_NONE 0
#define SQL_AM_CONNECTION 1
#define SQL_AM_STATEMENT 2
/* Bitmasks for SQL_ALTER_DOMAIN */
#define SQL_AD_CONSTRAINT_NAME_DEFINITION 0x00000001L
#define SQL_AD_ADD_DOMAIN_CONSTRAINT 0x00000002L
#define SQL_AD_DROP_DOMAIN_CONSTRAINT 0x00000004L
#define SQL_AD_ADD_DOMAIN_DEFAULT 0x00000008L
#define SQL_AD_DROP_DOMAIN_DEFAULT 0x00000010L
#define SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED 0x00000020L
#define SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE 0x00000040L
#define SQL_AD_ADD_CONSTRAINT_DEFERRABLE 0x00000080L
#define SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE 0x00000100L
/* SQL_CREATE_SCHEMA bitmasks */
#define SQL_CS_CREATE_SCHEMA 0x00000001L
#define SQL_CS_AUTHORIZATION 0x00000002L
#define SQL_CS_DEFAULT_CHARACTER_SET 0x00000004L
/* SQL_CREATE_TRANSLATION bitmasks */
#define SQL_CTR_CREATE_TRANSLATION 0x00000001L
/* SQL_CREATE_ASSERTION bitmasks */
#define SQL_CA_CREATE_ASSERTION 0x00000001L
#define SQL_CA_CONSTRAINT_INITIALLY_DEFERRED 0x00000010L
#define SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE 0x00000020L
#define SQL_CA_CONSTRAINT_DEFERRABLE 0x00000040L
#define SQL_CA_CONSTRAINT_NON_DEFERRABLE 0x00000080L
/* SQL_CREATE_CHARACTER_SET bitmasks */
#define SQL_CCS_CREATE_CHARACTER_SET 0x00000001L
#define SQL_CCS_COLLATE_CLAUSE 0x00000002L
#define SQL_CCS_LIMITED_COLLATION 0x00000004L
/* SQL_CREATE_COLLATION bitmasks */
#define SQL_CCOL_CREATE_COLLATION 0x00000001L
/* SQL_CREATE_DOMAIN bitmasks */
#define SQL_CDO_CREATE_DOMAIN 0x00000001L
#define SQL_CDO_DEFAULT 0x00000002L
#define SQL_CDO_CONSTRAINT 0x00000004L
#define SQL_CDO_COLLATION 0x00000008L
#define SQL_CDO_CONSTRAINT_NAME_DEFINITION 0x00000010L
#define SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED 0x00000020L
#define SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE 0x00000040L
#define SQL_CDO_CONSTRAINT_DEFERRABLE 0x00000080L
#define SQL_CDO_CONSTRAINT_NON_DEFERRABLE 0x00000100L
/* SQL_CREATE_TABLE bitmasks */
#define SQL_CT_CREATE_TABLE 0x00000001L
#define SQL_CT_COMMIT_PRESERVE 0x00000002L
#define SQL_CT_COMMIT_DELETE 0x00000004L
#define SQL_CT_GLOBAL_TEMPORARY 0x00000008L
#define SQL_CT_LOCAL_TEMPORARY 0x00000010L
#define SQL_CT_CONSTRAINT_INITIALLY_DEFERRED 0x00000020L
#define SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE 0x00000040L
#define SQL_CT_CONSTRAINT_DEFERRABLE 0x00000080L
#define SQL_CT_CONSTRAINT_NON_DEFERRABLE 0x00000100L
#define SQL_CT_COLUMN_CONSTRAINT 0x00000200L
#define SQL_CT_COLUMN_DEFAULT 0x00000400L
#define SQL_CT_COLUMN_COLLATION 0x00000800L
#define SQL_CT_TABLE_CONSTRAINT 0x00001000L
#define SQL_CT_CONSTRAINT_NAME_DEFINITION 0x00002000L
/* SQL_DDL_INDEX bitmasks */
#define SQL_DI_CREATE_INDEX 0x00000001L
#define SQL_DI_DROP_INDEX 0x00000002L
/* SQL_DROP_COLLATION bitmasks */
#define SQL_DC_DROP_COLLATION 0x00000001L
/* SQL_DROP_DOMAIN bitmasks */
#define SQL_DD_DROP_DOMAIN 0x00000001L
#define SQL_DD_RESTRICT 0x00000002L
#define SQL_DD_CASCADE 0x00000004L
/* SQL_DROP_SCHEMA bitmasks */
#define SQL_DS_DROP_SCHEMA 0x00000001L
#define SQL_DS_RESTRICT 0x00000002L
#define SQL_DS_CASCADE 0x00000004L
/* SQL_DROP_CHARACTER_SET bitmasks */
#define SQL_DCS_DROP_CHARACTER_SET 0x00000001L
/* SQL_DROP_ASSERTION bitmasks */
#define SQL_DA_DROP_ASSERTION 0x00000001L
/* SQL_DROP_TABLE bitmasks */
#define SQL_DT_DROP_TABLE 0x00000001L
#define SQL_DT_RESTRICT 0x00000002L
#define SQL_DT_CASCADE 0x00000004L
/* SQL_DROP_TRANSLATION bitmasks */
#define SQL_DTR_DROP_TRANSLATION 0x00000001L
/* SQL_DROP_VIEW bitmasks */
#define SQL_DV_DROP_VIEW 0x00000001L
#define SQL_DV_RESTRICT 0x00000002L
#define SQL_DV_CASCADE 0x00000004L
/* SQL_INSERT_STATEMENT bitmasks */
#define SQL_IS_INSERT_LITERALS 0x00000001L
#define SQL_IS_INSERT_SEARCHED 0x00000002L
#define SQL_IS_SELECT_INTO 0x00000004L
/* SQL_ODBC_INTERFACE_CONFORMANCE values */
#define SQL_OIC_CORE 1UL
#define SQL_OIC_LEVEL1 2UL
#define SQL_OIC_LEVEL2 3UL
/* SQL_SQL92_FOREIGN_KEY_DELETE_RULE bitmasks */
#define SQL_SFKD_CASCADE 0x00000001L
#define SQL_SFKD_NO_ACTION 0x00000002L
#define SQL_SFKD_SET_DEFAULT 0x00000004L
#define SQL_SFKD_SET_NULL 0x00000008L
/* SQL_SQL92_FOREIGN_KEY_UPDATE_RULE bitmasks */
#define SQL_SFKU_CASCADE 0x00000001L
#define SQL_SFKU_NO_ACTION 0x00000002L
#define SQL_SFKU_SET_DEFAULT 0x00000004L
#define SQL_SFKU_SET_NULL 0x00000008L
/* SQL_SQL92_GRANT bitmasks */
#define SQL_SG_USAGE_ON_DOMAIN 0x00000001L
#define SQL_SG_USAGE_ON_CHARACTER_SET 0x00000002L
#define SQL_SG_USAGE_ON_COLLATION 0x00000004L
#define SQL_SG_USAGE_ON_TRANSLATION 0x00000008L
#define SQL_SG_WITH_GRANT_OPTION 0x00000010L
#define SQL_SG_DELETE_TABLE 0x00000020L
#define SQL_SG_INSERT_TABLE 0x00000040L
#define SQL_SG_INSERT_COLUMN 0x00000080L
#define SQL_SG_REFERENCES_TABLE 0x00000100L
#define SQL_SG_REFERENCES_COLUMN 0x00000200L
#define SQL_SG_SELECT_TABLE 0x00000400L
#define SQL_SG_UPDATE_TABLE 0x00000800L
#define SQL_SG_UPDATE_COLUMN 0x00001000L
/* SQL_SQL92_PREDICATES bitmasks */
#define SQL_SP_EXISTS 0x00000001L
#define SQL_SP_ISNOTNULL 0x00000002L
#define SQL_SP_ISNULL 0x00000004L
#define SQL_SP_MATCH_FULL 0x00000008L
#define SQL_SP_MATCH_PARTIAL 0x00000010L
#define SQL_SP_MATCH_UNIQUE_FULL 0x00000020L
#define SQL_SP_MATCH_UNIQUE_PARTIAL 0x00000040L
#define SQL_SP_OVERLAPS 0x00000080L
#define SQL_SP_UNIQUE 0x00000100L
#define SQL_SP_LIKE 0x00000200L
#define SQL_SP_IN 0x00000400L
#define SQL_SP_BETWEEN 0x00000800L
#define SQL_SP_COMPARISON 0x00001000L
#define SQL_SP_QUANTIFIED_COMPARISON 0x00002000L
/* SQL_SQL92_RELATIONAL_JOIN_OPERATORS bitmasks */
#define SQL_SRJO_CORRESPONDING_CLAUSE 0x00000001L
#define SQL_SRJO_CROSS_JOIN 0x00000002L
#define SQL_SRJO_EXCEPT_JOIN 0x00000004L
#define SQL_SRJO_FULL_OUTER_JOIN 0x00000008L
#define SQL_SRJO_INNER_JOIN 0x00000010L
#define SQL_SRJO_INTERSECT_JOIN 0x00000020L
#define SQL_SRJO_LEFT_OUTER_JOIN 0x00000040L
#define SQL_SRJO_NATURAL_JOIN 0x00000080L
#define SQL_SRJO_RIGHT_OUTER_JOIN 0x00000100L
#define SQL_SRJO_UNION_JOIN 0x00000200L
/* SQL_SQL92_REVOKE bitmasks */
#define SQL_SR_USAGE_ON_DOMAIN 0x00000001L
#define SQL_SR_USAGE_ON_CHARACTER_SET 0x00000002L
#define SQL_SR_USAGE_ON_COLLATION 0x00000004L
#define SQL_SR_USAGE_ON_TRANSLATION 0x00000008L
#define SQL_SR_GRANT_OPTION_FOR 0x00000010L
#define SQL_SR_CASCADE 0x00000020L
#define SQL_SR_RESTRICT 0x00000040L
#define SQL_SR_DELETE_TABLE 0x00000080L
#define SQL_SR_INSERT_TABLE 0x00000100L
#define SQL_SR_INSERT_COLUMN 0x00000200L
#define SQL_SR_REFERENCES_TABLE 0x00000400L
#define SQL_SR_REFERENCES_COLUMN 0x00000800L
#define SQL_SR_SELECT_TABLE 0x00001000L
#define SQL_SR_UPDATE_TABLE 0x00002000L
#define SQL_SR_UPDATE_COLUMN 0x00004000L
/* SQL_SQL92_ROW_VALUE_CONSTRUCTOR bitmasks */
#define SQL_SRVC_VALUE_EXPRESSION 0x00000001L
#define SQL_SRVC_NULL 0x00000002L
#define SQL_SRVC_DEFAULT 0x00000004L
#define SQL_SRVC_ROW_SUBQUERY 0x00000008L
/* SQL_SQL92_VALUE_EXPRESSIONS bitmasks */
#define SQL_SVE_CASE 0x00000001L
#define SQL_SVE_CAST 0x00000002L
#define SQL_SVE_COALESCE 0x00000004L
#define SQL_SVE_NULLIF 0x00000008L
/* SQL_STANDARD_CLI_CONFORMANCE bitmasks */
#define SQL_SCC_XOPEN_CLI_VERSION1 0x00000001L
#define SQL_SCC_ISO92_CLI 0x00000002L
/* SQL_UNION_STATEMENT bitmasks */
#define SQL_US_UNION SQL_U_UNION
#define SQL_US_UNION_ALL SQL_U_UNION_ALL
#endif /* ODBCVER >= 0x0300 */
/* SQL_DTC_TRANSITION_COST bitmasks */
#define SQL_DTC_ENLIST_EXPENSIVE 0x00000001L
#define SQL_DTC_UNENLIST_EXPENSIVE 0x00000002L
/* additional SQLDataSources fetch directions */
#if (ODBCVER >= 0x0300)
#define SQL_FETCH_FIRST_USER 31
#define SQL_FETCH_FIRST_SYSTEM 32
#endif /* ODBCVER >= 0x0300 */
/* Defines for SQLSetPos */
#define SQL_ENTIRE_ROWSET 0
/* Operations in SQLSetPos */
#define SQL_POSITION 0 /* 1.0 FALSE */
#define SQL_REFRESH 1 /* 1.0 TRUE */
#define SQL_UPDATE 2
#define SQL_DELETE 3
/* Operations in SQLBulkOperations */
#define SQL_ADD 4
#define SQL_SETPOS_MAX_OPTION_VALUE SQL_ADD
#if (ODBCVER >= 0x0300)
#define SQL_UPDATE_BY_BOOKMARK 5
#define SQL_DELETE_BY_BOOKMARK 6
#define SQL_FETCH_BY_BOOKMARK 7
#endif /* ODBCVER >= 0x0300 */
/* Lock options in SQLSetPos */
#define SQL_LOCK_NO_CHANGE 0 /* 1.0 FALSE */
#define SQL_LOCK_EXCLUSIVE 1 /* 1.0 TRUE */
#define SQL_LOCK_UNLOCK 2
#define SQL_SETPOS_MAX_LOCK_VALUE SQL_LOCK_UNLOCK
/* Macros for SQLSetPos */
#define SQL_POSITION_TO(hstmt,irow) SQLSetPos(hstmt,irow,SQL_POSITION,SQL_LOCK_NO_CHANGE)
#define SQL_LOCK_RECORD(hstmt,irow,fLock) SQLSetPos(hstmt,irow,SQL_POSITION,fLock)
#define SQL_REFRESH_RECORD(hstmt,irow,fLock) SQLSetPos(hstmt,irow,SQL_REFRESH,fLock)
#define SQL_UPDATE_RECORD(hstmt,irow) SQLSetPos(hstmt,irow,SQL_UPDATE,SQL_LOCK_NO_CHANGE)
#define SQL_DELETE_RECORD(hstmt,irow) SQLSetPos(hstmt,irow,SQL_DELETE,SQL_LOCK_NO_CHANGE)
#define SQL_ADD_RECORD(hstmt,irow) SQLSetPos(hstmt,irow,SQL_ADD,SQL_LOCK_NO_CHANGE)
/* Column types and scopes in SQLSpecialColumns. */
#define SQL_BEST_ROWID 1
#define SQL_ROWVER 2
/* Defines for SQLSpecialColumns (returned in the result set)
SQL_PC_UNKNOWN and SQL_PC_PSEUDO are defined in sql.h */
#define SQL_PC_NOT_PSEUDO 1
/* Defines for SQLStatistics */
#define ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -