Difference between revisions of "Portable SQL"

From Linuxnetworks
Jump to: navigation, search
(Join syntax)
(accessing metadata)
Line 14: Line 14:
 
### [[Portable SQL/Statements/Data retrieval/Join syntax|Join syntax]]
 
### [[Portable SQL/Statements/Data retrieval/Join syntax|Join syntax]]
 
## [[Portable SQL/Statements/Generating IDs|Generating IDs]]
 
## [[Portable SQL/Statements/Generating IDs|Generating IDs]]
 +
## Accessing metadata
 +
### [[Portable_SQL/Statements/Access_metadata/Tables|Tables]]
 +
### [[Portable_SQL/Statements/Access_metadata/Table_columns|Table columns]]
 +
### [[Portable_SQL/Statements/Access_metadata/Views|Views]]
 
# SQL tips
 
# SQL tips
 
## [[Portable SQL/Tips/Identifier Naming|Identifier Naming]]
 
## [[Portable SQL/Tips/Identifier Naming|Identifier Naming]]
 
## [[Portable SQL/Tips/Handling generated IDs|Handling generated IDs]]
 
## [[Portable SQL/Tips/Handling generated IDs|Handling generated IDs]]
 
## [[Portable SQL/Tips/Replacing records|Replacing records]]
 
## [[Portable SQL/Tips/Replacing records|Replacing records]]

Revision as of 13:48, 3 May 2008

The ANSI SQL standard exists for years but it's still difficult to write SQL statements which are portable across most database engine implementations. This guide tries to give you tips about what is possible keeping the most common database implementations in mind and where the limits of portable SQL for this engines are.

Feel free to add your own tips if you like ...

  1. Common tips
    1. Database differences
    2. Aliases
    3. Quoting
  2. SQL statements
    1. Transactions
    2. Data manipulation
    3. Data retrieval
      1. Simple SELECT
      2. Join syntax
    4. Generating IDs
    5. Accessing metadata
      1. Tables
      2. Table columns
      3. Views
  3. SQL tips
    1. Identifier Naming
    2. Handling generated IDs
    3. Replacing records
Retrieved from "https://www.linuxnetworks.de/doc/index.php?title=Portable_SQL&oldid=3266"