SQL Dialects Reference/References
From Wikibooks, open books for an open world
[edit] References
[edit] Standards
- SQL-86
- SQL-89
- SQL-92 — full text is available
- SQL:1999 — can be purchased from ISO
- SQL:2003 — can be purchased from ISO
- SQL:2008 — can be purchased from ISO
[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
[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. http://www.oreilly.com/catalog/sqlnut/chapter/ch04.html.
- 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.
