权威的SQL标准文档 [英] Authoritative SQL standard documentation

问题描述

我很好奇要了解有关各种SQL标准的更多详细信息，例如SQL-92，SQL:99，SQL:2003，SQL:2008等.

I'm curious to know some more details about the various SQL standard's, i.e. SQL-92, SQL:99, SQL:2003, SQL:2008 etc. There is a short and useful overview on Wikipedia, with links to very expensive documents. Why are those documents not open to public? Can I find some open and free information?

请不要发布您从Google找到的链接.我只对权威性文档感兴趣.

Please, don't post links you found from Google. I'm interested in somewhat authoritative documentation only.

推荐答案

引用自我的一个网站:

我们都喜欢开源软件.如果不是很好 国际标准文件(例如SQL标准)将是 也打开吗?

We all love open source software. Wouldn’t it be great if international standard documents such as the SQL standard would be open too?

事实上:它们是！

但是，它们不是免费的，而是公开的.非常像开源 该软件不一定是免费的.很多时候，我们忽略了这些 差异.仅仅因为我们必须为标准支付费用并不意味着 这是秘密.

However, they are not free—just public. Very much like open source software is not necessarily free. Too often, we neglect these differences. Just because we have to pay for the standard doesn't mean it is secret.

SQL标准最相关的部分(第2部分)的下载是 可用于价格为60美元ANSI .可以购买包含所有零件的CD 从ISO购买，价格为352瑞士法郎.这不是免费的，但价格合理.

A download of the most relevant part of the SQL standard—part 2—is available for USD 60 at ANSI. A CD with all parts on it can be bought from ISO for CHF 352. Not free, but affordable.

您在一些评论中提到，您对第2部分最感兴趣，因此花费60美元可能是您的最佳选择.

You mentioned in some comments that you are mostly interested in part 2, so spending USD 60 might be your best option.

如果您只需要了解2003年前的语法，则有两个不错的免费资源:

If you just need to know about the syntax up to 2003, there are two great free resources:

• SQL-92，SQL:1999和SQL:2003的BNF语法: http://www. savage.net.au/SQL/
• 用于SQL-92，SQL:1999和SQL:2003的在线验证器: http://developer .mimer.se/validator/index.htm

• BNF grammar of SQL-92, SQL:1999 and SQL:2003: http://www.savage.net.au/SQL/
• Online validator for SQL-92, SQL:1999 and SQL:2003: http://developer.mimer.se/validator/index.htm

最后，MariaDB上提供了"SQL-99完全，真正"的完整文本知识库.但是，这本书写于1999年，当时没有数据库实际支持所描述的功能.使用此资源时请记住这一点.

Finally, the complete text of "SQL-99 Complete, Really" is available at the MariaDB knowledge base. However, this book was written in 1999 when no database actually supported the described features. Keep that in mind when using this resource.

其他答案也提到了网络上可用的标准免费"副本.是的，它们是大多数的草稿版本.我无法确定其中哪些是合法的，所以我宁愿不链接它们.

Other answers also mentioned "free" copies of the standards available on the web. Yes there are—those are mostly draft versions. I can't tell which of them are legal, so I rather not link them.

最后是一个自我广告:我刚刚发布了 http://modern-sql.com/向开发人员提供易于理解的方式来解释该标准.请注意，实际的标准文本的写法就像法律一样:)根据您的背景，可能始终不是您想要的.

Finally a little self ad: I've just launched http://modern-sql.com/ to explain the standard in an easily accessible way to developers. Note that the actual standards text is written like laws are written :) Depending on your background, that might anyway not what you want.

这篇关于权威的SQL标准文档的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！