Friday, March 11, 2005

Comparison of different SQL implementations

Comparison of different SQL implementations lists several databases (PostgreSQL, DB2, Microsoft SQL Server, MySQL and Oracle) and how they differ (when they do), from the SQL Standards. Not all conform to the standards (DB2, MS SQL and Oracle comply with SQL-92; PostgreSQL and MySQL do not comply fully (MySQL lacks views, PostgreSQL dissallows updates of data in views)). Very useful resource when porting SQL code between systems.


Tags:

No comments: