Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
Stairway to SQL Dialects
Tags

The SQL language has developed many dialects over the years, with MySQL, PostgreS and Oracle all popular extensions of the core language. This Stairway Series gives an overview of how SQL dialects formed and looks at some of the most commonly-used dialects in detail.

Stairway to SQL Dialects Level 1: Overview

In the first level of his Stairway to SQL Dialects, Joe Celko looks at the origins of the SQL language and how the language has spawned the various different dialects in use today.  Read more...
By Joe Celko 2012/10/31 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,862 reads

Stairway to SQL Dialects Level 2: Postgres

Level 2 of this stairway explains how to convert data declaration language (DDL) statements and data manipulation language (DML) statements from Postgres to Microsoft SQL Server.  Read more...
By Joe Celko 2012/11/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,834 reads

Stairway to SQL Dialects Level 3: MySQL

As part of the LAMP stack, MySQL is incredibly important for providing a reliable and platform-agnostic database platform for web development. This level looks at the syntax of MySQL and how to best port SQL code to a MySQL environment.  Read more...
By Joe Celko 2012/12/05 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,637 reads
Sign up to our RSS feed and get notified as soon as we publish a new level in the Stairway! Rss