SQL Server Performance

Help with SQL Standards

Discussion in 'General DBA Questions' started by api11, Apr 10, 2005.

  1. api11 New Member

    What are the differences between SQL-89, SQL-92 and SQL-1999 AND whether ORACLE AND SQL Server fully adhere to SQL-1999?
  2. FrankKalis Moderator

    SQL 92 is still the de-facto standard. SQL99 adresses some of the modern aspects like Object-relational models, call-level interfaces and integrity management. But to the best of my knowledge SQL99 is not adapted yet by ANSI.

    Neither SQL Server, nor Oracle, nor any other major RDBMS fulls conforms to SQL 92 and/or SQL99.
    This is not exactly what you've asked for, but here's a good overview on the compliance of SQL Server, DB2 and Oracle with Codd's 12 rules:
    http://www.insidesql.de/component/option,com_bookmarks/Itemid,42/task,view/catid,9/id,54/

    --
    Frank Kalis
    SQL Server MVP
    http://www.insidesql.de

Share This Page