当前位置：文江博客话题详情

在哪里可以找到 Jet 4.0 引擎使用的特定类型 SQL 的文档？

发布于 2024-10-16 09:34:37 字数 78 浏览 5 评论 0原文

我认为这与 MS Access 使用的相同，我认为与 MySQL 和其他人使用的不同。我需要 SQL 语言的这种特定“种类”或“子集”的文档。

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

余生一个溪 2024-10-23 09:34:37

此处是最新版本的 Access SQL 参考 (Access 2010) 。

然而，@Remou 的回答中的指南是 Microsoft 提供的最有用的资源，指出它们已有十多年的历史，并且没有考虑到 Access 2007 ACE 时代所做的更改（即多值数据类型 - 颤抖！）

明智的一句话：Access SQL Reference 包含太多包含和遗漏的错误，此处无法详细说明，因此这里有一个简短的示例：

CREATE TABLE 语句 (Microsoft Access SQL)

CREATE TEMPORARY TABLE 语法从未受 Access 支持，而且 Access 也不支持甚至还有临时表功能。看起来编写帮助的人从 SQL-92 规范中删除了这一点，认为 Access 兼容 SQL-92！

WITH COMPRESSION 语法仅在 Access 的 ANSI-92 查询模式**中受支持。如果指出这一点将会很有帮助。

Quote: “您可以在适用于名为 CONSTRAINT 的多字段的命名 CONSTRAINT 子句中使用 NOT NULL..” - - 同样，这不是 Access 的功能，尝试使用该语法会生成错误。

DEFAULT：能够为列指定 DEFAULT 值非常有用，Access 确实支持此语法，但此帮助页面中缺少此语法。

IDENTITY：Access SQL 参考中缺少此关键字，此页面是找到它的合理位置。

CHECK 约束：可能是 Access SQL 最强大的功能之一，但在所有 Microsoft 文档中几乎完全不存在，仅在几篇文章中简短提及。

正如我所说，这只是一页！是的，我已经向 Microsoft 和 Access 团队提供了有关这些错误的反馈（事实上，每次他们发布新版本时），但错误仍然存在:(

这是指 Access 专有的 ANSI-92 查询模式，不要与SQL-92 标准。遗憾的是，Access 永远不会兼容 SQL-92，甚至不兼容入门级 SQL-92。Access 团队似乎已从帮助中删除了 ANSI-92 查询模式页面，可能也是因为这个原因。包含错误，例如 ORDER BY 中的 LIMIT TO nn ROWS 不受 Access 或其 SQL 语法的支持。

Here is the most recent version of the Access SQL Reference (Access 2010).

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!)

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 Statement (Microsoft Access SQL)

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 syntax is only supported in Access's ANSI-92 Query Mode**. It would be helpful if this was pointed out.

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: 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: this keyword is missing from the Access SQL Reference and this page is the logical place to find it.

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.

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 :(

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.

回复收藏 0 原文