Consider using standard SQL

Almost all relational databases extend the standard set of SQL commands. If these extensions are used, then portability rapidly degrades.

In some applications, such portability may not be a concern. However, if portability is important, then it's clearly an advantage to use only the standard SQL commands. Mimer has published this SQL validator which verifies compliance with different versions of the SQL standard.



See Also :
Keep SQL out of code
Would you use this technique?
Yes   No   Undecided   
© 2014 Hirondelle Systems | Source Code | Contact | License | RSS
Individual code snippets can be used under this BSD license - Last updated on September 21, 2013.
Over 2,000,000 unique IPs last year - Built with WEB4J.
- In Memoriam : Bill Dirani -