📄 sqlext.h
字号:
#define SQL_SC_SQL92_FULL 0x00000008L/* SQL_DATETIME_LITERALS masks */#define SQL_DL_SQL92_DATE 0x00000001L#define SQL_DL_SQL92_TIME 0x00000002L#define SQL_DL_SQL92_TIMESTAMP 0x00000004L#define SQL_DL_SQL92_INTERVAL_YEAR 0x00000008L#define SQL_DL_SQL92_INTERVAL_MONTH 0x00000010L#define SQL_DL_SQL92_INTERVAL_DAY 0x00000020L#define SQL_DL_SQL92_INTERVAL_HOUR 0x00000040L#define SQL_DL_SQL92_INTERVAL_MINUTE 0x00000080L#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 SQL_QUICK 0#define SQL_ENSURE 1/* Defines for SQLStatistics (returned in the result s⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -