Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2

Thread: SQL Help

  1. #1
    New to the CF scene
    Join Date
    Feb 2012
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL Help

    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.

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    27,700
    Thanks
    80
    Thanked 4,658 Times in 4,620 Posts
    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.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •