|
JET SQL保留字是一些不允许在 JET SQL 语句中直接出现的字符，一旦未加任何处理就直接使用的 JET SQL 语句中，将导致错误。你必须在保留字两边加上方括号 []
比如：BEGIN 就是一个 JET SQL 保留字。
| select stop,begin from TableName |
这句语句就无法返回正确结果。
正确的写法应该是：
| select stop,[begin] from TableName |
以下是 JET SQL 的保留字列表
无论 Microsoft Jet 数据库引擎是被 Microsoft Access 调用、被Data Access Objects (DAO) 调用、被Microsoft OLE DB Provider for Microsoft Jet(MS OLEDB)调用、还是被 Microsoft Access ODBC driver 调用，Microsoft Jet 数据库引擎会运行在几种不同的运行模式下。
现在Microsoft Jet 数据库引擎可以运行在 ANSI 模式或者non-ANSI(传统)模式下。 每种运行模式下，对保留字的定义都会有一些细微的差异。在一个模式下可以被运行的字符可能在其他模式下是一个保留字，因而会导致查询错误。 下面这篇文档提供了几种模式下可能会引起错误的保留字。记得 SQL 语句中使用下列保留字时在保留字两边加上方括号，比如 [AND]。
A
ABSOLUTE ACTION ADD ADMINDB
ALL ALLOCATE ALPHANUMERIC ALTER
AND ANY ARE AS
ASC ASSERTION AT AUTHORIZATION
AUTOINCREMENT AVG
B
BAND BEGIN BETWEEN BINARY
BIT BIT_LENGTH BNOT BOR
BOTH BXOR BY BYTE
C
CASCADE CASCADED CASE CAST
CATALOG CHAR CHARACTER CHAR_LENGTH
CHARACTER_LENGTH CHECK CLOSE COALESCE
COLLATE COLLATION COLUMN COMMIT
COMP COMPRESSION CONNECT CONNECTION
CONSTRAINT CONSTRAINTS CONTAINER CONTINUE
CONVERT CORRESPONDING COUNT COUNTER
CREATE CREATEDB CROSS CURRENCY
CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP
CURRENT_USER CURSOR
D
DATABASE DATE DATETIME DAY
DEALLOCATE DEC DECIMAL DECLARE
DEFAULT DEFERRABLE DEFERRED DELETE
DESC DESCRIBE DESCRIPTOR DIAGNOSTICS
DISALLOW DISCONNECT DISTINCT DOMAIN
DOUBLE DROP
E
ELSE END END-EXEC ESCAPE
EXCEPT EXCEPTION EXCLUSIVECONNECT EXEC
EXECUTE EXISTS EXTERNAL EXTRACT
F
FALSE FETCH FIRST FLOAT
FLOAT4 FLOAT8 FOR FOREIGN
FOUND FROM FULL
G
GENERAL GET GLOBAL GO
GOTO GRANT GROUP GUID
H
HAVING HOUR
I
IDENTITY IEEEDOUBLE IEEESINGLE IGNORE
IMAGE IMMEDIATE IN INDEX
INDICATOR INHERITABLE INITIALLY INNER
INPUT INSENSITIVE INSERT INT
INTEGER INTEGER1 INTEGER2 INTEGER4
INTERSECT INTERVAL INTO IS
ISOLATION
J
JOIN
K
KEY
L
LANGUAGE LAST LEADING LEFT
LEVEL LIKE LOCAL LOGICAL
LOGICAL1 LONG LONGBINARY LONGCHAR
LONGTEXT LOWER
M
MATCH MAX MEMO MIN
MINUTE MODULE MONEY MONTH
N
NAMES NATIONAL NATURAL NCHAR
NEXT NO NOT NOTE
NULL NULLIF NUMBER NUMERIC
O
OBJECT OCTET_LENGTH OF OLEOBJECT
ON ONLY OPEN OPTION
OR ORDER OUTER OUTPUT
OVERLAPS OWNERACCESS
P
PAD PARAMETERS PARTIAL PASSWORD
PERCENT PIVOT POSITION PRECISION
PREPARE PRESERVE PRIMARY PRIOR
PRIVILEGES PROC PROCEDURE PUBLIC
Q R
READ REAL REFERENCES RELATIVE
RESTRICT REVOKE RIGHT ROLLBACK
ROWS
S
SCHEMA SCROLL SECOND SECTION
SELECT SELECTSCHEMA SELECTSECURITY SESSION
SESSION_USER SET SHORT SINGLE
SIZE SMALLINT SOME SPACE
SQL SQLCODE SQLERROR SQLSTATE
STRING SUBSTRING SUM SYSTEM_USER
T
TABLE TABLEID TEMPORARY TEXT
THEN TIME TIMESTAMP TIMEZONE_HOUR
TIMEZONE_MINUTE TO TOP TRAILING
TRANSACTION TRANSFORM TRANSLATE TRANSLATION
TRIM TRUE
U
UNION UNIQUE UNIQUEIDENTIFIER UNKNOWN
UPDATE UPDATEIDENTITY UPDATEOWNER UPDATESECURITY
UPPER USAGE USER USING
V
VALUE VALUES VARBINARY VARCHAR
VARYING VIEW
W
WHEN WHENEVER WHERE WITH
WORK WRITE
X Y
YEAR YESNO
Z
ZONE |
参考地址：
http://support.microsoft.com/default.aspx?kbid=248738
http://support.microsoft.com/default.aspx?kbid=321266
| 
1702438
