Re: where can i get the ANSI SQL standards?
From: Michael D. Long <lead_dog_at_bellsouth.net>
Date: Sat, 30 Sep 2000 12:43:31 -0400
Message-ID: <VFoB5.11463$103.94849_at_news1.atl>
Date: Sat, 30 Sep 2000 12:43:31 -0400
Message-ID: <VFoB5.11463$103.94849_at_news1.atl>
I searched via Yahoo and eventually found the ANSI SQL '92 document - both in text and ps formats. However, as you have indicated the language and formatting combine to make it a more difficult read than necessary.
There are a lot of good papers available that cover specific points and provide clarification. Some of these are team efforts by multiple vendors producing DBMS's.
-- Michael D. Long http://extremedna.homestead.com "Joe Celko" <71062.1056_at_compuserve.com> wrote in message news:8qvvog$cqo$1_at_nnrp1.deja.com...Received on Sat Sep 30 2000 - 18:43:31 CEST
>
> >> What about a fella named Celko? <<
>
> ISO makes it money selling hardcopy documents and they are opposed to
> putting anything on the Internet or having it passed around in
> electronic format.
>
> ANSI gets its money from membership dues and has wanted to get a
> website with all the standards on it. But they are a member of ISO and
> cannot do it with the common standards like SQL.
>
> Besides, the things are damn near unreadable. I like SQL: THE STANDARD
> HANDBOOK by Stephen Canaan and Gerard Otten (ISBN 0-07-707664-8)as my
> guide. THE SQL STANDARD by Chris DATE (ISBN 0-201-96426-0) is okay,
> but Chris will editorialize about the things he does not like. For
> example, the informationon NULLs is in one place, instead of appearing
> in all the various places they occur.
>
> --CELKO--
> Joe Celko, SQL and Database Consultant
> When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc)
> which can be cut and pasted into Query Analyzer is appreciated.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.