SQL dialects reference

From Wikibooks, the open-content textbooks collection

[edit] Contents

1. Introduction
2. Data structure definition
   1. Data types
      1. Numeric types
      2. Character types
      3. Date and time types
      4. Binary types
      5. Large object types
      6. Misc types
   2. Delimited identifiers
   3. Auto-increment column
3. Functions and expressions
   1. Math functions
      1. Trigonometric functions
      2. Numeric functions
      3. Aggregate functions
   2. Date and time functions
   3. String functions
   4. Misc expressions
4. Select queries
   1. Select without tables
   2. Limiting results of select query
   3. Hierarchical Queries
5. Write queries
   1. Replace query
   2. Insert results from select query into existing table
   3. Save results from select query as new table
6. Transactions
7. Procedural language
   1. Stored procedures
   2. User-defined functions (UDFs)
8. SQL XML
9. Administration
10. References