SQL-92

SQL-92 was the third revision of the SQL database query language. Unlike SQL-89, it was a major revision of the standard. For all but a few minor incompatibilities, the SQL-89 standard is forwards-compatible with SQL-92.

Later revisions of the standard include 1999 (SQL3), 2003, and 2008.

New Features

• SQL Agent
• New data types defined: <code>DATE</code>, <code>TIME</code>, <code>TIMESTAMP</code>, <code>INTERVAL</code>, <code>BIT</code> string, <code>VARCHAR</code> strings, and <code>NATIONAL CHARACTER</code> strings.
• Support for additional character sets beyond the base requirement for representing SQL statements.
• New scalar operations such as string concatenation, date and time mathematics, and conditional statements.
• New set operations such as <code>UNION JOIN</code>, <code>NATURAL JOIN</code>, set differences, and set intersections.
• Support for alterations of schema definitions via <code>ALTER</code> and <code>DROP</code>.
• Bindings for C, Ada, and MUMPS.
• New features for user privileges.
• New integrity-checking functionality such as within a <code>CHECK</code> constraint.
• New schema definitions for "Information".
• Dynamic execution of queries (as opposed to prepared).
• Better support for remote database access.
• Temporary tables.
• Transaction isolation levels.
• New operations for changing data types on the......
...

Read More