eBooksAll.Com
All ebooks are providing for research and information. We are not from or against any sect or group.

SQL Dialects Reference

By Admin on October 3, 2017

SQL Dialects Reference

Publisher: Wikibooks 2010

Description:
This wikibook is a compact comparative reference for several SQL language dialects. It lists particular common tasks and problems resolved in terms of several popular SQL server implementations. When possible, it tries to emphasize an universal solution. When it’s not possible, it tries to list best practices.

Home page url

Download or read it online here: 
Read online
(online html)

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
ExpressionsLanguageSQLSQL Server
Related Posts

Top 10 Free Books And Resources For Learning TensorFlow

Impatient Perl

How To Code in Python 3

Upgrading to PHP 7

Apress.-.PHP.Solutions2nd.Edition.2010

Syberia-2 Walkthrough Game Guides

Apress.PHP.Objects.Patterns.and.Practice.3rd.Edition.May.2010
Comments (0)
Add Comment