Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2004
    Posts
    14

    Thumbs up Unanswered: How to get The Standard Query Language's general standard??

    I wanna find a general standard in some database like ms sql,oracle,sybase..This standard is a rfc or another document which declared the base role how to work with sql..
    Can u give me any thread??

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The only SQL standards that I recognize are the ISO SQL Standard and the ANSI standard.

    -PatP

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I'm not too sure how much use buying one of the standards would be, as meritoriuos they are. Virtually no server meets the (most recent) standards in their entireity, AND most servers have there own extensions and variations on the standard. So either, you use the reduced common set applicable to all db's, or get a specialist book on the db you are working with.

    Personally I found the O'Reilly "SQL in a nutshell" a good basic reference But not a primer (it covers MySQL, Oracle, SQL Server (and one other I can't remember)). Its a bit sparse on examples (but that would be the same with a standards manual), but it provides sufficent pointers to jog the memory, or show the way forward. But there are others with masses of text, information and examples. The "in a nutshell" series are probably not the "best" for beginners, don't take offence I've made no assessment of your competance.
    Last edited by healdem; 12-05-04 at 08:26. Reason: aah shpelling mishtakes yet again

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    cleverpig, i would definitely buy a book, it is much easier

    if you really want to see the standard, you may read a draft of sql-92 here --
    http://www.contrib.andrew.cmu.edu/~s...ql/sql1992.txt

    note that most databases implement most of sql-92

    don't spend too much time in there, though, because if you learn something in sql-92 there's no guarantee that it'll work in your particular database
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'm certainly game with the idea of buying a book. As a general rule, they are significantly easier to read than the standards are!

    Just as a note, the standards are what both the database engine writers and the book writers use for a reference. The standard is where they start. If you are looking for a clear, technically correct statement of what is required for a given level of SQL implementation, the standard document is where I would start.

    The standard documents might not be suitable for everyone, but why start third-hand (with the interpretation provided by the book's writer)?

    -PatP

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    depends what cleverpig is trying to achieve. If CleverPig is going to write a SQL database then go to the standards to check what you are doing is correct, if CleverPig is writing some application software accessing a specific SQL engine then go buy a book relevent to that SQL implementation, or buy a book which identifies where varius flavours of SQL implementations vary from the standard and make sure Cleverpig writes code compliant to the lowest common denominator (if you wan ttomake your code protable).

    The standard identifies what the server "should" do, but the servers often:- don't do it,
    or dont do it the way the standard says they should,
    or has implemented some other features not thought of at the time the standard was thrashed out, or has retained some features from previous versions which are not compatible with the current standard
    even if they are compliant with most of the standard, they are still not standard compliant. On dodgy ground here but I'm not aware of any SQL implementation which is truly compliant to the satndards.
    Last edited by healdem; 12-05-04 at 12:12.

  7. #7
    Join Date
    Dec 2004
    Posts
    14

    Thumbs up THX for the replies!!

    Thank for your replies..They are very good suggestion about how to get and learn sql standard..
    I think the sql standard is a common role,but the some sql implement has his owner's role base on thie sql standard!..
    So we can use it fixable just as you said..

Posting Permissions

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