SQL-92 Compliance

The Desktop Database Drivers and the underlying Microsoft Jet engine are not SQL-92 compliant. They do support many features that have been defined in SQL-92, but some features supported in the drivers are not supported in SQL-92. The following are the major differences between the two:

• The Desktop Database Drivers use SQL that supports more powerful expressions than those specified by SQL-92.
  
  
• Different rules apply to the Between…And operator (BETWEEN predicate).
  
  
• The Desktop Database Drivers use SQL that supports different keywords than those specified by SQL-92.

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, but are not specified by SQL-92:

• The TRANSFORM statement, which provides support for crosstab queries
  
  
• Additional aggregate functions (StDev and VarP)