Portable SQL

From Linuxnetworks
Revision as of 13:57, 13 May 2007 by Nose (Talk | contribs)

Jump to: navigation, search

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.

  1. Common tips
    1. Database differences
    2. Aliases
    3. Quoting
  2. SQL statements
    1. Transactions
    2. Data manipulation