Jump to content

SQL Dialects Reference/References

From Wikibooks, open books for an open world

Standards

[edit | edit source]
  • SQL-86
  • SQL-89
  • SQL-92 — full text is available
  • SQL:1999 — can be purchased from ISO
  • SQL:2003 — can be purchased from ISO
  • working draft of SQL:2008, downloadable from Whitemarsh Information Systems Corporation.
  • SQL:2008 — can be purchased from ISO
  • SQL:2011 — can be purchased from ISO

Official product documentations

[edit | edit source]

Single implementation references and cheat sheets

[edit | edit source]

Comparisons

[edit | edit source]
  • 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. (2001). "SQL Functions". SQL in a Nutshell. Cambridge, MS: O'Reilly. ISBN 1-56592-744-3. {{cite book}}: Unknown parameter |chapterurl= ignored (|chapter-url= suggested) (help); Unknown parameter |coauthors= ignored (|author= suggested) (help); Unknown parameter |month= ignored (help)
  • 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

Migration

[edit | edit source]