在哪里可以找到Jet 4.0引擎使用的特定SQL的文档? [英] Where can I find the documentation for the particular kind of SQL used by the Jet 4.0 engine?
问题描述
我认为这与MS Access所使用的相同，我认为与MySQL及其他公司所使用的不相同.我需要这种特定的SQL语言种类"或子集"的文档.
Which I think is the same as the one used by MS Access, which I think is not the same as the one used by MySQL and others. I need the documentation for this particular "kind" or "subset" of SQL language.
推荐答案
此处是Access SQL参考(Access 2010)的最新版本.
Here is the most recent version of the Access SQL Reference (Access 2010).
但是，@ Remou的答案所提供的指南是Microsoft提供的最有用的资源，并指出它们已经使用了10多年，并且没有考虑对Access 2007 ACE时代所做的更改(即，多值数据类型-发抖！)
However, the guides as per @Remou's answer are the most useful resource Microsoft makes available, noting they are over a decade old and do not take account of changes made to Access 2007 ACE era (i.e. multi-valued data types -- shudder!)
明智的一句话:《 Access SQL参考》中包含的包含和遗漏错误太多，因此在这里不做详细介绍，因此这里是一个简短的示例:
A word to the wise: the Access SQL Reference contains errors of inclusion and omission too numerous to detail here, so here's a brief example:
CREATE TABLE语句(Microsoft Access SQL)
CREATE TABLE Statement (Microsoft Access SQL)
CREATE TEMPORARY TABLE语法，并且Access甚至没有临时表功能.似乎有人在编写帮助"，从而认为Access符合SQL-92，从而将它从SQL-92规范中取消了！
CREATE TEMPORARY TABLE syntax has never been supported by Access and Access doesn't even have a temporary tables feature. It looks like someone writing the Help lifted this from the SQL-92 spec thinking that Access was SQL-92 compliant!
WITH COMPRESSION语法仅在Access的ANSI-92查询模式**中受支持.如果指出这一点将很有帮助.
WITH COMPRESSION syntax is only supported in Access's ANSI-92 Query Mode**. It would be helpful if this was pointed out.
引用:您可以在适用于...名为CONSTRAINT的多字段的命名CONSTRAINT子句中使用NOT NULL .."-再次，这不是Access的功能，并且试图使用语法会产生错误.
Quote: "You can use NOT NULL.. within a named CONSTRAINT clause that applies to... a multiple-field named CONSTRAINT" -- again, this is not a feature of Access and attempting to use the syntax generates an error.
DEFAULT:能够为列指定DEFAULT值非常有用，Access确实支持该语法，但此帮助页面中缺少该语法.
DEFAULT: it is very useful to be able to specify a DEFAULT value for a column and Access does indeed suport this syntax yet it is missing from this page of the help.
IDENTITY:《 Access SQL参考》中缺少此关键字，并且此页面是找到它的逻辑位置.
IDENTITY: this keyword is missing from the Access SQL Reference and this page is the logical place to find it.
CHECK约束:可能是Access SQL的最强大功能之一，但在所有微软文档中几乎完全没有，仅在几篇文章中作了简要介绍.
CHECK constraint: potentially one of the most powerful features of Access SQL but almost completely absent from all Microsoft documentation, merely gets a brief mention in a couple of articles.
正如我所说，这只是一页！是的，我已经就这些错误向Microsoft和Access Team提供了反馈(实际上，他们每次发布新版本)，但是这些错误仍然存在:(
As I said, this is just one page! And yes I have given feedback to Microsoft and the Access Team about these errors (each time they release a new version, in fact) but the errors remain :(
这是指Access的专有ANSI-92查询模式，请勿与SQL-92标准混淆.访问不符合SQL-92，并且遗憾的是永远不会符合SQL-92，甚至不符合入门级SQL-92.看来Access小组已经从帮助中删除了他们的ANSI-92查询模式页面，可能是因为它也包含包含错误，例如Access或其SQL语法不支持ORDER BY中的LIMIT TO nn ROWS.
This referes to Access's proprietary ANSI-92 Query Mode, not to be confused with the SQL-92 Standard. Access is not, and sadly never will be, SQL-92 compliant, not even entry level SQL-92. It seems the Access team have removed their ANSI-92 Query Mode page from the Help, possibly because that too contained errors of inclusion e.g. LIMIT TO nn ROWS in the ORDER BY is not supported by either Access or its SQL syntax.
这篇关于在哪里可以找到Jet 4.0引擎使用的特定SQL的文档?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
