Difference between revisions of "Portable SQL"
From Linuxnetworks
(triggers) |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 13: | Line 13: | ||
### [[Portable SQL/Statements/Data retrieval/Simple SELECT|Simple SELECT]] | ### [[Portable SQL/Statements/Data retrieval/Simple SELECT|Simple SELECT]] | ||
### [[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/IDs|Handling IDs]] |
| + | ### [[Portable SQL/Statements/IDs/Generating IDs|Generating IDs]] | ||
## Accessing metadata | ## Accessing metadata | ||
### [[Portable_SQL/Statements/Access_metadata/Tables|Tables]] | ### [[Portable_SQL/Statements/Access_metadata/Tables|Tables]] | ||
Latest revision as of 11:20, 4 September 2010
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 ...
- Common tips
- SQL statements
- SQL tips
