Post reply

Question on SQL 92 and 99

  • July 9, 2003 at 12:32 am

    #80524

    Hi all,

    does anyone know where I can get the original SQL-92 and SQL-99 standard?

    I've already tried http://www.ansi.org but wasn't successful.

    Any help is greatly appreciated!

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • July 9, 2003 at 2:10 am

    #464631

    Found one for the 92 version:

    http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

  • July 9, 2003 at 2:46 am

    #464636

    quote:

    Found one for the 92 version:

    http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

    hurray, thanks for this Noel!

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • July 9, 2003 at 3:56 am

    #464653

    Here is 99

    http://www.ncb.ernet.in/education/modules/dbms/SQL99/

  • July 9, 2003 at 4:17 am

    #464656

    Hi James,

    quote:

    http://www.ncb.ernet.in/education/modules/dbms/SQL99/

    again many thanks to you, but what is somehow frustrating, is how could you both obviously find something so quick that I was looking for quite some time now. Did you use Google beyond the 3 - 4 page?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • July 9, 2003 at 4:46 am

    #464658

    I cheated. If you look at the link posted by Noel you will find on the first page the documents id. "ISO/IEC 9075:1992" so I use WebFerret to find "ISO/IEC 9075" and I checked out http://www.iso.org which ISO is a pain. But in WebFerret doing boolean ["ISO/IEC 9075" AND 1999] I got several dozen hits then I just went to a few until I found one PDF then from there I ripped off the PDF filename for the subsection and found it the way it was (got lucky there). So no I just built upon existing knowledge from this thread to find the rest.

  • July 9, 2003 at 5:04 am

    #464662

    quote:

    I cheated. If you look at the link posted by Noel you will find on the first page the documents id. "ISO/IEC 9075:1992" so I use WebFerret to find "ISO/IEC 9075" and I checked out http://www.iso.org which ISO is a pain. But in WebFerret doing boolean ["ISO/IEC 9075" AND 1999] I got several dozen hits then I just went to a few until I found one PDF then from there I ripped off the PDF filename for the subsection and found it the way it was (got lucky there). So no I just built upon existing knowledge from this thread to find the rest.

    and again thanks!

    Today is learning day for me. Not only because of SQL standards, but I learned that there is a product named WebFerret, which will be from now on a good friend for me.

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • July 9, 2003 at 5:06 am

    #464663

    Yes, I have been using the freeware product since it first came out and then ZDNet bought it and canned several of the other ferrets such a newsferret. But the product makes finding information so much easier and that is how I found this site originally.

  • July 10, 2003 at 5:47 am

    #464809

    Hi James,

    quote:

    I cheated. If you look at the link posted by Noel you will find on the first page the documents id. "ISO/IEC 9075:1992" so I use WebFerret to find "ISO/IEC 9075" and I checked out http://www.iso.org which ISO is a pain. But in WebFerret doing boolean ["ISO/IEC 9075" AND 1999] I got several dozen hits then I just went to a few until I found one PDF then from there I ripped off the PDF filename for the subsection and found it the way it was (got lucky there). So no I just built upon existing knowledge from this thread to find the rest.

    ahem, in my first excitement I've forgotten that I can't copy and paste from pdf files. Do you have a HTML Link?

    BTW: Our network admins don't allow me to use WebFerret, before they have tested. Could only be a matter on month, or so

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • July 10, 2003 at 6:03 am

    #464817

    Understandable.

    As for text link no. But you may not be familiar with Acrobat reader. If the data was text to begine with it is still text now. On the toolbar you will find the "Text Select TOol" option which you can change to by pressing "V" when your cursor is inside the document (mouse has clicked inside to give focus). The you can highlight and copy or use edit to do Select All (CTRL+A works also) for the page and do copy.

  • July 10, 2003 at 6:07 am

    #464821

    quote:

    As for text link no. But you may not be familiar with Acrobat reader. If the data was text to begine with it is still text now. On the toolbar you will find the "Text Select TOol" option which you can change to by pressing "V" when your cursor is inside the document (mouse has clicked inside to give focus). The you can highlight and copy or use edit to do Select All (CTRL+A works also) for the page and do copy.

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply