预定义常量

下列常量由此扩展定义，且仅在此扩展编译入 PHP 或在运行时动态载入时可用。

SQLSRV_FETCH_ASSOC ( integer )

Forces sqlsrv_fetch_array() to return an associative array when passed as a parameter.

SQLSRV_FETCH_NUMERIC ( integer )

Forces sqlsrv_fetch_array() to return an array with numeric when passed as a parameter.

SQLSRV_FETCH_BOTH ( integer )

Forces sqlsrv_fetch_array() to return an array with both associative and numeric keys when passed as a parameter (the default behavior).

SQLSRV_ERR_ALL ( integer )

Forces sqlsrv_errors() to return both errors and warings when passed as a parameter (the default behavior).

SQLSRV_ERR_ERRORS ( integer )

Forces sqlsrv_errors() to return errors only (no warnings) when passed as a parameter.

SQLSRV_ERR_WARNINGS ( integer )

Forces sqlsrv_errors() to return warnings only (no errors) when passed as a parameter.

SQLSRV_LOG_SYSTEM_ALL ( integer )

Turns on logging of all subsystems when passed to sqlsrv_configure() as a parameter.

SQLSRV_LOG_SYSTEM_CONN ( integer )

Turns on logging of connection activity when passed to sqlsrv_configure() as a parameter.

SQLSRV_LOG_SYSTEM_INIT ( integer )

Turns on logging of initialization activity when passed to sqlsrv_configure() as a parameter.

SQLSRV_LOG_SYSTEM_OFF ( integer )

Turns off logging of all subsystems when passed to sqlsrv_configure() as a parameter.

SQLSRV_LOG_SYSTEM_STMT ( integer )

Turns on logging of statement activity when passed to sqlsrv_configure() as a parameter.

SQLSRV_LOG_SYSTEM_UTIL ( integer )

Turns on logging of error function activity when passed to sqlsrv_configure() as a parameter.

SQLSRV_LOG_SEVERITY_ALL ( integer )

Specifies that errors, warnings, and notices will be logged when passed to sqlsrv_configure() as a parameter.

SQLSRV_LOG_SEVERITY_ERROR ( integer )

Specifies that errors will be logged when passed to sqlsrv_configure() as a parameter.

SQLSRV_LOG_SEVERITY_NOTICE ( integer )

Specifies that notices will be logged when passed to sqlsrv_configure() as a parameter.

SQLSRV_LOG_SEVERITY_WARNING ( integer )

Specifies that warnings will be logged when passed to sqlsrv_configure() as a parameter.

SQLSRV_NULLABLE_YES ( integer )

Indicates that a column is nullable.

SQLSRV_NULLABLE_NO ( integer )

Indicates that a column is not nullable.

SQLSRV_NULLABLE_UNKNOWN ( integer )

Indicates that it is not known if a column is nullable.

SQLSRV_PARAM_IN ( integer )

Indicates an input parameter when passed to sqlsrv_query() or sqlsrv_prepare() .

SQLSRV_PARAM_INOUT ( integer )

Indicates a bidirectional parameter when passed to sqlsrv_query() or sqlsrv_prepare() .

SQLSRV_PARAM_OUT ( integer )

Indicates an output parameter when passed to sqlsrv_query() or sqlsrv_prepare() .

SQLSRV_PHPTYPE_INT ( integer )

Specifies an integer PHP data type. For usage information, see » How to: Specify PHP Types.

SQLSRV_PHPTYPE_DATETIME ( integer )

Specifies a datetime PHP data type. For usage information, see » How to: Specify PHP Types.

SQLSRV_PHPTYPE_FLOAT ( integer )

Specifies a float PHP data type. For usage information, see » How to: Specify PHP Types.

SQLSRV_PHPTYPE_STREAM ( integer )

Specifies a PHP stream. This constant works like a function and accepts an encoding constant. See the SQLSRV_ENC_* constants. For usage information, see » How to: Specify PHP Types.

SQLSRV_PHPTYPE_STRING ( integer )

Specifies a string PHP data type. This constant works like a function and accepts an encoding constant. See the SQLSRV_ENC_* constants. For usage information, see » How to: Specify PHP Types.

SQLSRV_ENC_BINARY ( integer )

Specifies that data is returned as a raw byte stream from the server without performing encoding or translation. For usage information, see » How to: Specify PHP Types.

SQLSRV_ENC_CHAR ( integer )

Data is returned in 8-bit characters as specified in the code page of the Windows locale that is set on the system. Any multi-byte characters or characters that do not map into this code page are substituted with a single byte question mark (?) character. This is the default encoding. For usage information, see » How to: Specify PHP Types.

UTF-8 ( integer )

Specifies that data is returned with UTF-8 encoding. For usage information, see » How to: Specify PHP Types.

SQLSRV_SQLTYPE_BIGINT ( integer )

Describes the bigint SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_BINARY ( integer )

Describes the binary SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_BIT ( integer )

Describes the bit SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_CHAR ( integer )

Describes the char SQL Server data type. This constant works like a function and accepts a parameter indicating the number characters. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_DATE ( integer )

Describes the date SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_DATETIME ( integer )

Describes the datetime SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_DATETIME2 ( integer )

Describes the datetime2 SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_DATETIMEOFFSET ( integer )

Describes the datetimeoffset SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_DECIMAL ( integer )

Describes the decimal SQL Server data type. This constant works like a function and accepts two parameters indicating (in order) precision and scale. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_FLOAT ( integer )

Describes the float SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_IMAGE ( integer )

Describes the image SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_INT ( integer )

Describes the int SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_MONEY ( integer )

Describes the money SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_NCHAR ( integer )

Describes the nchar SQL Server data type. This constant works like a function and accepts a single parameter indicating the character count. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_NUMERIC ( integer )

Describes the numeric SQL Server data type. This constant works like a function and accepts two parameter indicating (in order) precision and scale. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_NVARCHAR ( integer )

Describes the nvarchar SQL Server data type. This constant works like a function and accepts a single parameter indicating the character count. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_NVARCHAR ('max') ( integer )

Describes the nvarchar(MAX) SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_NTEXT ( integer )

Describes the ntext SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_REAL ( integer )

Describes the real SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_SMALLDATETIME ( integer )

Describes the smalldatetime SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_SMALLINT ( integer )

Describes the smallint SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_SMALLMONEY ( integer )

Describes the smallmoney SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_TEXT ( integer )

Describes the text SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_TIME ( integer )

Describes the time SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_TIMESTAMP ( integer )

Describes the timestamp SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_TINYINT ( integer )

Describes the tinyint SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_UNIQUEIDENTIFIER ( integer )

Describes the uniqueidentifier SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_UDT ( integer )

Describes the UDT SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_VARBINARY ( integer )

Describes the varbinary SQL Server data type. This constant works like a function and accepts a single parameter indicating the byte count. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_VARBINARY ('max') ( integer )

Describes the varbinary(MAX) SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_VARCHAR ( integer )

Describes the varchar SQL Server data type. This constant works like a function and accepts a single parameter indicating the character count. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_VARCHAR ('max') ( integer )

Describes the varchar(MAX) SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_SQLTYPE_XML ( integer )

Describes the XML SQL Server data type. For usage information, see » How to: Specify SQL Types.

SQLSRV_TXN_READ_UNCOMMITTED ( integer )

Inidicates a transaction isolation level of READ UNCOMMITTED. This value is used to set the TransactionIsolation level in the $connectionOptions arrary passed to sqlsrv_connect() .

SQLSRV_TXN_READ_COMMITTED ( integer )

Inidicates a transaction isolation level of READ COMMITTED. This value is used to set the TransactionIsolation level in the $connectionOptions arrary passed to sqlsrv_connect() .

SQLSRV_TXN_REPEATABLE_READ ( integer )

Inidicates a transaction isolation level of REPEATABLE READ. This value is used to set the TransactionIsolation level in the $connectionOptions arrary passed to sqlsrv_connect() .

SQLSRV_TXN_SNAPSHOT ( integer )

Inidicates a transaction isolation level of SNAPSHOT. This value is used to set the TransactionIsolation level in the $connectionOptions arrary passed to sqlsrv_connect() .

SQLSRV_TXN_READ_SERIALIZABLE ( integer )

Inidicates a transaction isolation level of SERIALIZABLE. This value is used to set the TransactionIsolation level in the $connectionOptions arrary passed to sqlsrv_connect() .

SQLSRV_CURSOR_FORWARD ( integer )

Inidicates a forward-only cursor. For usage information, see » Specifying a Cursor Type and Selecting Rows.

SQLSRV_CURSOR_STATIC ( integer )

Inidicates a static cursor. For usage information, see » Specifying a Cursor Type and Selecting Rows.

SQLSRV_CURSOR_DYNAMIC ( integer )

Inidicates a dynamic cursor. For usage information, see » Specifying a Cursor Type and Selecting Rows.

SQLSRV_CURSOR_KEYSET ( integer )

Inidicates a keyset cursor. For usage information, see » Specifying a Cursor Type and Selecting Rows.

SQLSRV_CURSOR_BUFFERED ( integer )

Creates a client-side cursor query. Lets you access rows in any order. For usage information, see » Specifying a Cursor Type and Selecting Rows.

SQLSRV_SCROLL_NEXT ( integer )

Specifies which row to select in a result set. For usage information, see » Specifying a Cursor Type and Selecting Rows.

SQLSRV_SCROLL_PRIOR ( integer )

Specifies which row to select in a result set. For usage information, see » Specifying a Cursor Type and Selecting Rows.

SQLSRV_SCROLL_FIRST ( integer )

Specifies which row to select in a result set. For usage information, see » Specifying a Cursor Type and Selecting Rows.

SQLSRV_SCROLL_LAST ( integer )

Specifies which row to select in a result set. For usage information, see » Specifying a Cursor Type and Selecting Rows.

SQLSRV_SCROLL_ABSOLUTE ( integer )

Specifies which row to select in a result set. For usage information, see » Specifying a Cursor Type and Selecting Rows.

SQLSRV_SCROLL_RELATIVE ( integer )

Specifies which row to select in a result set. For usage information, see » Specifying a Cursor Type and Selecting Rows.