Additional ODBC SQL Server Driver Information

When connected to Microsoft SQL Server 6.5:

• The USER keyword is part of the supported ODBC SQL grammar.
• Static server side cursors can be used on ODBC catalog functions.
• The DEFAULT keyword is supported in canonical procedure invocations. Use the DEFAULT keyword to specify a default procedure parameter.
• Default procedure parameters can be used anywhere. When connected to SQL Server version 6.0 or earlier, all default procedure parameters must be after all non-default procedure parameters.
• Canonical procedure invocations that include a NULL literal parameter are executed as an RPC request. When connected to SQL Server version 6.0 or earlier, the request is issued as a language event.
• SQLTablePrivileges supports search patterns for the table owner and table name parameters. (All servers.)
• SQLTablePrivileges and SQLColumnPrivileges return information in the GRANTOR column of the results set to reflect grants that are used with the WITH GRANT clause.
• The following ODBC catalog functions can be called inside a transaction:

• Because the SQLSetStmtOption SQL_MAX_ROWS option maps to the SET ROWCOUNT statement (when connected to any version of SQL Server), setting this option causes all Transact-SQL® statements to stop processing when they have each affected the specified number of rows. This includes triggers and data modification statements, such as INSERT, UPDATE, and DELETE, as well as the filling of a Keyset cursor at the specified number of rows. This option should be used with caution and primarily with the SELECT statement.
• The following fDescType attribute parameters of SQLColAttributes are supported only when server side cursors are used:

  SQL_COLUMN_TABLE_NAME

  SQL_COLUMN_OWNER_NAME

  SQL_COLUMN_QUALIFIER_NAME

• Parameters to an ODBC canonical procedure call that are only output parameters can contain non-valid input data.
• The ODBC like escape clause is supported.
• All ODBC outer join extensions can be used without restrictions.
• When storing data in character or binary datatypes, any non-blank (for character) or non-zero (for binary) data truncation will cause SQL_ERROR to be returned. A subsequent call to SQLError will return an szSqlState of "22001."
• SQLSetPos has the following performance enhancements:
  • SQLSetPos supports asynchronous execution.
  • Calling SQLSetPos with an fOption of SQL_DELETE and an irow of 0 is a single server operation.
  • Calling SQLSetPos with an fOption of SQL_UPDATE or SQL_ADD and an irow of 0 uses a batch of multiple RPCs.
• When not in auto-commit mode, the ODBC SQL Server driver uses SET IMPLICIT_TRANSACTION ON to increase performance.

When connected to SQL Server 6.0 and later, bookmarks are supported for Static and Keyset cursors.