Help with SQL Standards | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Help with SQL Standards

What are the differences between SQL-89, SQL-92 and SQL-1999 AND whether ORACLE AND SQL Server fully adhere to SQL-1999?
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
]]>