ANSI SQL specs ?

Question

Post reply

ANSI SQL specs ?

hbkdba

Ten Centuries

Points: 1224
More actions
August 2, 2003 at 1:32 am

#81357

Are the ANSI SQL specs ('92, '99) available for download ?
thanks

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

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Hi hbkdba,

quote:
Are the ANSI SQL specs ('92, '99) available for download ?

yes, they are!

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=13985

Cheers,

Frank

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

Hi hbkdba,

quote:
Are the ANSI SQL specs ('92, '99) available for download ?

yes, they are!

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=13985

Cheers,

Frank

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

hbkdba Ten Centuries Points: 1224 More actions · Answer 3

hbkdba

Ten Centuries

Points: 1224

August 4, 2003 at 2:56 am

#468389

Frank,

Thanks a lot !

Steven.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

quote:
Thanks a lot !

get several cups of coffee, when you print those thousands of pages

Cheers,

Frank

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

hbkdba Ten Centuries Points: 1224 More actions · Answer 5

hbkdba

Ten Centuries

Points: 1224

August 4, 2003 at 11:27 am

#468474

sure will !

mbaker SSC Eights! Points: 901 More actions · Answer 6

The ANSI standards refer to the ISO standards. If you need the ISO SQL specs, I would suggest purchasing them from ISO.org. Both ANSI and ISO sell copies of their standards as one method of covering the cost of creating and revising the standards.(http://www.iso.org/iso/en/StandardsQueryFormHandler.StandardsQueryFormHandler?scope=CATALOGUE&sortOrder=ISO&committee=ALL&isoDocType=ALL&title=true&keyword=sql)

Corrigendum are frequently publish and are usually available for free at http://www.ansi.org. Search on SQL.

The links in the previous forum are incorrect. One link is to a presentation "Great News, The Relational Data Model is Dead!" via a software company, the other link is to a text file of the "Second Informal Review Draft" of the 1992 standard.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 7

quote:
The ANSI standards refer to the ISO standards. If you need the ISO SQL specs, I would suggest purchasing them from ISO.org. Both ANSI and ISO sell copies of their standards as one method of covering the cost of creating and revising the standards.

I know this. And think, it's a shame!

quote:
Corrigendum are frequently publish and are usually available for free at http://www.ansi.org. Search on SQL.

again yes, costs are covered when purchasing the original document.

quote:
The links in the previous forum are incorrect. One link is to a presentation "Great News, The Relational Data Model is Dead!" via a software company, the other link is to a text file of the "Second Informal Review Draft" of the 1992 standard.

how come, I've downloaded the standards from this locations?

Sure, there are some ppt files hanging around.

And then there are also some pdf's (for 1999) and a txt file (for 1992) containing the standard.

Cheers,

Frank

Sorry, should have read:

'Sure, there are several pdf files hanging around. One of them contains the standard'

Edited by - a5xo3z1 on 08/05/2003 08:42:17 AM

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

hbkdba Ten Centuries Points: 1224 More actions · Answer 8

It really don't understand the filosify behind getting payed for standards-publications.

I thought they should spread as much as possible to become a standard,

But then again, I might be wrong of course ...

Edited by - hbkdba on 08/06/2003 03:16:31 AM

Frank Kalis SSC Guru Points: 111183 More actions · Answer 9

quote:
It really don't understand the filosify behind getting payed for standards-publications.
I thought they should spread as much as possible to become a standard,
But then again, I might be wrong of course ...

I can't identity either. It might be the wrong place here, but I have a strong believe in OpenSource, OpenKnowledge... things.

So I think it is ridiculous to charge money (even if it is only some 148 Swiss Francs as for SQL99) for something that SHOULD be free !!!

Btw, I know a friend who has a friend who knows someone that says, that this is the reason for some people to get married

I've been to ANSI and ISO homepage before, and thought that the standards were not publicly available until NPeeters and Antares686 proved me wrong.

Fr the SQL99 pdf file, I'm pretty sure it is the final version of the standard. At least it states so.

And for SQL92 I think even if it is only a second draft (had to look this up) it shouldn't differ significantly from the final version. It is good enough 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]