Difference between revisions of "Portable SQL"

From Linuxnetworks
Jump to: navigation, search
(tips)
(remove redirects)
Line 4: Line 4:
  
 
# Common tips
 
# Common tips
## [[Portable SQL - DBMS Differences|Database differences]]
+
## [[Portable SQL/Common/DBMS Differences|Database differences]]
## [[Portable SQL - Aliases|Aliases]]
+
## [[Portable SQL/Common/Aliases|Aliases]]
## [[Portable SQL - Quoting|Quoting]]
+
## [[Portable SQL/Common/Quoting|Quoting]]
 
# SQL statements
 
# SQL statements
## [[Portable SQL - Transactions|Transactions]]
+
## [[Portable SQL/Statements/Transactions|Transactions]]
## [[Portable SQL - Data manipulation statements|Data manipulation]]
+
## [[Portable SQL/Statements/Data manipulation|Data manipulation]]

Revision as of 16:29, 17 May 2007

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