SQL Dialects Reference

Category:Books to be merged#SQL%20Dialects%20Reference Category:Books to be merged#SQL%20Dialects%20Reference Category:Books with print version#SQL%20Dialects%20Reference

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. Subqueries
    2. Select without tables
    3. Limiting results of select query
    4. 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
    4. Update returning
  6. Transactions
  7. Procedural language
    1. Stored procedures
    2. User-defined functions (UDFs)
  8. SQL XML
  9. Administration
  10. References

See also

Category:Subject:SQL/all books Category:Subject:Computer programming languages/all books Category:Subject:Computer programming/all books Category:Subject:Computer science/all books Category:Subject:Computing/all books Category:Subject:Books by subject/all books Category:Subject:Computing/all books Category:Subject:Books by subject/all books Category:Subject:Database management systems/all books Category:Subject:Computer software/all books Category:Subject:Computing/all books Category:Subject:Books by subject/all books Category:Book:SQL Dialects Reference#%20 Category:Book:Wikibooks Stacks/Books#SQL%20Dialects%20ReferenceCategory:Shelf:SQL Category:Shelf:SQL/all books Category:Shelf:Computer programming/all books#Computer%20programming Category:Shelf:Computer programming languages/all books#Computer%20programming%20languages Category:Shelf:Computer science/all books#Computer%20science Category:Shelf:Computer software/all books#Computer%20software Category:Department:Computing/all books#Computing Category:Shelf:Database management systems/all books#Database%20management%20systems Category:Alphabetical/S Category:Books nearing completionCategory:Books by completion status/all books
Category:Alphabetical/S Category:Book:SQL Dialects Reference Category:Book:Wikibooks Stacks/Books Category:Books by completion status/all books Category:Books nearing completion Category:Books to be merged Category:Books with PDF version Category:Books with print version Category:Department:Computing/all books Category:Shelf:Computer programming/all books Category:Shelf:Computer programming languages/all books Category:Shelf:Computer science/all books Category:Shelf:Computer software/all books Category:Shelf:Database management systems/all books Category:Shelf:SQL Category:Shelf:SQL/all books Category:Subject:Books by subject/all books Category:Subject:Computer programming/all books Category:Subject:Computer programming languages/all books Category:Subject:Computer science/all books Category:Subject:Computer software/all books Category:Subject:Computing/all books Category:Subject:Database management systems/all books Category:Subject:SQL Category:Subject:SQL/all books