The Microsoft® SQL Server™ ODBC driver extends SQLGetStmtAttr to expose driver-specific statement attributes. All driver-specific attributes are SQLINTEGER values.
The SQL Server ODBC driver SQL_TEXTPTR_LOGGING attribute exposes logging of operations on columns containing text or image data.
| Value | Description |
|---|---|
| SQL_TL_OFF | Logging operations performed on text, ntext, and image data is disabled. |
| SQL_TL_ON | Default. Logging of operations performed on text, ntext, and image data is enabled. |
The SQL_SOPT_SS_CURRENT_COMMAND attribute exposes the current command of a command batch. The return is an integer specifying the location of the command in the batch.
SQL_SOPT_SS_HIDDEN_COLUMNS exposes, in the result set, columns hidden in a SQL Server SELECT FOR BROWSE statement. The driver does not expose these columns by default.
| Value | Description |
|---|---|
| SQL_HC_OFF | Default. FOR BROWSE columns are hidden from the result set. |
| SQL_HC_ON | Exposes FOR BROWSE columns. |
SQL_SOPT_SS_NCOUNT_STATUS indicates the current setting of the NOCOUNT option, which controls whether SQL Server reports the numbers of rows affected by a statement when SQLRowCount is called.
| Value | Description |
|---|---|
| SQL_NC_OFF | NOCOUNT is OFF. SQLRowCount always returns 0. |
| SQL_NC_ON | NOCOUNT is ON. The counts of rows affected are returned by SQLRowCount. |