SQL Dialects Reference/References

From Wikibooks, the open-content textbooks collection

[edit] References

[edit] Official product documentations

• DB2 Version 9 Information Center
• MySQL 5.0 reference manual
• PostgreSQL 8.2 reference manual
• SQLite documentation
• Firebird / Interbase 6 language reference (ZIP archive, 8.9MB)
• OpenLink Virtuoso Universal Server Documentation
• Oracle Database 10g2 SQL Reference
• Microsoft SQL Server Documentation
• Linter SQL Server Documentation (english, old version);Linter SQL Server Documentation (russian)

[edit] Single implementation references and cheat sheets

• Oracle PL/SQL Cheatsheet
• Oracle XML Cheatsheet

[edit] Comparisons

• Comparison of different SQL implementations
• Comparison of Oracle, MySQL and PostgreSQL DBMS by Computing Division of Fermi National Accelerator Laboratory
• SQL Function Reference: Oracle vs. SQL Server
• Kline, Kevin E., Kline, Daniel (January 2001). “SQL Functions”, SQL in a Nutshell. Cambridge, MS: O'Reilly. ISBN 1-56592-744-3.
• SQL Functions — MySQL vs Oracle comparison by Eric Brian
• Standard SQL - an article by Peter Gulutzan that compares SQL standards support in DB2, MSSQL and Oracle

[edit] Migration

• Converting MySQL to PostgreSQL
• SQLWays database migration software documentation, provides many comparisons of SQL dialects differences.