• Various implementations
• Differences between implementations
• Compliance with ANSI SQL
• Interactive SQL statements
• Using variables
• Using parameters
This hour covers extensions to American National Standards Institute (ANSI)-standard SQL. Although most implementations conform to the standard, many vendors have provided extensions to standard SQL through various enhancements.
Numerous SQL implementations are released by various vendors. All the relational database vendors could not possibly be mentioned; a few of the leading implementations, however, are discussed. The implementations discussed here are MySQL, Microsoft SQL Server, and Oracle. ...