Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: SQL Help
11-14-2012, 03:37 PM #1
- Join Date
- Feb 2012
- Thanked 0 Times in 0 Posts
Just wondering if any of you could provide me with any help to the following statement.
"SQL has a well defined standard that enables portability between different database environments”.
I understand SQL is used across all the major RDBMS but in different flavours, for want of a better word.
11-14-2012, 07:37 PM #2
Ummm...and what "help" do you want?
Yes, in theory ANSI SQL is portable. In practice every DB indeed has its own "flavor", particularly when it comes to DATETIME data type (no two of the major DBs store DATETIME the same or use the same functions) and to functions in support of string manipulation.
MySQL is especially egregious in doing things in its own way. For example, its support for GROUP BY is not the same as that of any other DB that I know of.An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.