SQL-92

to get instant updates about 'SQL-92' on your MyPage. Meet other similar minded people. Its Free!

X 

All Updates


Description:
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

No feeds found

All
Posting your question. Please wait!...


No updates available.
No messages found
Suggested Pages
Tell your friends >
about this page
 Create a new Page
for companies, colleges, celebrities or anything you like.Get updates on MyPage.
Create a new Page
 Find your friends
  Find friends on MyPage from