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).
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for