MDAC 2.5 SDK - ODBC Desktop Database Drivers

SQL-92 Compliance

The ODBC Desktop Database Drivers and the underlying Microsoft Jet engine are not SQL-92 compliant. They support many features that have been defined in SQL-92. Some features supported in the driver are not supported in SQL-92. For more information, see the Microsoft Jet Database Engine Programmer's Guide. The following are the major differences between the two:

• The SQL used by the Desktop Database Drivers supports more powerful expressions than those specified by SQL-92.
  
  
• Different rules apply to the BETWEEN predicate.
  
  
• The SQL used by the Desktop Database Drivers and ANSI SQL supports different keywords.

The following SQL-92 features are not supported by Microsoft Jet SQL:

• Security statements, such as GRANT and LOCK.
  
  
• DISTINCT with aggregate function references.

The following features are enhancements in the SQL used by the Desktop Database Drivers that are not specified by SQL-92:

• The TRANSFORM statement providing support for crosstab queries.
  
  
• Additional aggregate functions (StDev and VarP).

Note   The Desktop Database Drivers support the standard ANSI syntax for % (percent) and _ (underscore), not * (asterisk) and ? (question mark).