• 企业400电话
  • 微网小程序
  • AI电话机器人
  • 电商代运营
  • 全 部 栏 目

    企业400电话 网络优化推广 AI电话机器人 呼叫中心 网站建设 商标✡知产 微网小程序 电商运营 彩铃•短信 增值拓展业务
    ASP常见的保留字整理(变量与表名注意不能用)
    许多人在编写程序的时候因为贪图方便或不小心使用到程式的保留字,有时明明程序没有错,就是无法正确执行。您知道有哪些常见的保留字吗? 

    下面的都是编程程序与表名都不能使用,如果不小心使用了,就需要下面的方法解决下
    当用USER作为数据库表名时,出错的解决办法
    1.因为User是关键字,所以更改表名即可解决。
    2.如果不想更改表名,那么我们在操作此表时,不能用User,而应该用[User],例如:

    SELECT UserName FROM [User] WHERE UserId = 1
    INSERT INTO [User](UserName,PassWord) VALUES('admin','admin')。

    Microsoft Access

    保留字

    -A
    ADD
    ALL
    Alphanumeric
    ALTER
    AND
    ANY
    Application
    AS
    ASC
    Assistant
    AUTOINCREMENT
    Avg
    -B
    BETWEEN
    BINARY
    BIT
    BOOLEAN
    BY
    BYTE
    -C
    CHAR, CHARACTER
    COLUMN
    CompactDatabase
    CONSTRAINT
    Container
    Count
    COUNTER
    CREATE
    CreateDatabase
    CreateField
    CreateGroup
    CreateIndex
    CreateObject
    CreateProperty
    CreateRelation
    CreateTableDef
    CreateUser
    CreateWorkspace
    CURRENCY
    CurrentUser
    -D
    DATABASE
    DATE
    DATETIME
    DELETE
    DESC
    Description
    DISALLOW
    DISTINCT
    DISTINCTROW
    Document
    DOUBLE
    DROP
    -E
    Echo
    Else
    End
    Eqv
    Error
    EXISTS
    Exit
    -F
    FALSE
    Field, Fields
    FillCache
    FLOAT, FLOAT4, FLOAT8
    FOREIGN
    Form, Forms
    FROM
    Full
    FUNCTION
    -G
    GENERAL
    GetObject
    GetOption
    GotoPage
    GROUP
    GROUP BY
    GUID
    -H
    HAVING
    -I
    Idle
    IEEEDOUBLE, IEEESINGLE
    If
    IGNORE
    Imp
    IN, In
    INDEX
    Index, Indexes
    INNER
    INSERT
    InsertText
    INT, INTEGER, INTEGER1, INTEGER2, INTEGER4
    INTO
    IS, Is
    -J
    JOIN
    -K
    KEY
    -L
    LEFT
    Level
    Like
    LOGICAL, LOGICAL1
    LONG, LONGBINARY, LONGTEXT
    -M
    Macro
    Match
    Max, Min, Mod
    MEMO
    Module
    MONEY
    Move
    -N
    NAME
    NewPassword
    NO
    Not
    NULL
    NUMBER, NUMERIC
    -O
    Object
    OLEOBJECT
    OFF
    ON
    OpenRecordset
    OPTION
    OR, Or
    ORDER
    Outer
    OWNERACCESS
    -P
    Parameter
    PARAMETERS
    Partial
    PERCENT
    PIVOT
    PRIMARY
    PROCEDURE
    Property
    -Q
    Queries
    Query
    Quit
    -R
    REAL
    Recalc
    Recordset
    REFERENCES
    Refresh
    RefreshLink
    RegisterDatabase
    Relation
    Repaint
    RepairDatabase
    Report
    Reports
    Requery
    RIGHT
    -S
    SCREEN
    SECTION
    SELECT)
    SET
    SetFocus
    SetOption
    SHORT
    SINGLE
    SMALLINT
    SOME
    SQL
    StDev, StDevP
    STRING
    Sum
    -T
    TABLE
    TableDef, TableDefs
    TableID
    TEXT
    TIME, TIMESTAMP
    TOP
    TRANSFORM
    TRUE
    Type
    -U
    UNION
    UNIQUE
    UPDATE
    User
    -V
    VALUE
    VALUES
    Var, VarP
    VARBINARY, VARCHAR
    -W
    WHERE
    WITH
    Workspace
    -X
    Xor
    -Y
    Year
    YES
    YESNO


    MySQL

    ADD
    ALL
    ALTER
    ANALYZE
    AND
    AS
    ASC
    AUTO_INCREMENT

    BDB
    BERKELEYDB
    BETWEEN
    BIGINT
    BINARY
    BLOB
    BOTH
    BY

    CASCADE
    CASE
    CHANGE
    CHAR
    CHARACTER
    COLUMN
    COLUMNS
    CONSTRAINT
    CREATE
    CROSS
    CURRENT_DATE
    CURRENT_TIME
    CURRENT_TIMESTAMP
    DATABASE
    DATABASES
    DAY_HOUR
    DAY_MINUTE
    DAY_SECOND
    DEC DECIMAL
    DEFAULT
    DELAYED
    DELETE
    DESC
    DESCRIBE
    DISTINCT
    DISTINCTROW
    DOUBLE
    DROP

    ELSE
    ENCLOSED
    ESCAPED
    EXISTS
    EXPLAIN

    FIELDS
    FLOAT
    FOR
    FOREIGN
    FROM
    FULLTEXT
    FUNCTION

    GRANT
    GROUP

    HAVING
    HIGH_PRIORITY
    HOUR_MINUTE
    HOUR_SECOND

    IF
    IGNORE
    IN
    INDEX
    INFILE
    INNER
    INNODB
    INSERT
    INT
    INTEGER
    INTERVAL
    INTO
    IS JOIN

    KEY
    KEYS
    KILL

    LEADING
    LEFT
    LIKE
    LIMIT
    LINES
    LOAD
    LOCK
    LONG
    LONGBLOB
    LONGTEXT
    LOW_PRIORITY

    MASTER_SERVER_ID MATCH
    MEDIUMBLOB
    MEDIUMINT
    MEDIUMTEXT
    MIDDLEINT
    MINUTE_SECOND
    MRG_MYISAM

    NATURAL
    NOT
    NULL
    NUMERIC

    ON
    OPTIMIZE
    OPTION
    OPTIONALLY
    OR
    ORDER
    OUTER
    OUTFILE

    PARTIAL
    PRECISION
    PRIMARY
    PRIVILEGES
    PROCEDURE
    PURGE

    READ
    REAL
    REFERENCES
    REGEXP
    RENAME
    REPLACE
    REQUIRE
    RESTRICT
    RETURNS
    REVOKE
    RIGHT
    RLIKE

    SELECT
    SET
    SHOW
    SMALLINT
    SONAME
    SQL_BIG_RESULT
    SQL_CALC_FOUND_ROWS SQL_SMALL_RESULT
    SSL
    STARTING
    STRAIGHT_JOIN STRIPED

    TABLE
    TABLES
    TERMINATED
    THEN
    TINYBLOB
    TINYINT
    TINYTEXT
    TO
    TRAILING

    UNION
    UNIQUE
    UNLOCK
    UNSIGNED
    UPDATE
    USAGE
    USE
    USER_RESOURCES
    USING

    VALUES
    VARBINARY
    VARCHAR
    VARYING
    WHEN
    WHERE
    WITH
    WRITE

    XOR

    YEAR_MONTH

    ZEROFILL
    您可能感兴趣的文章:
    • Access保留字变量名列表
    • 验证SQL保留字
    • php 保留字列表
    • ASP.NET系统关键字及保留字列表整理
    • Java的关键字与保留字小结
    上一篇:asp中日期时间函数介绍
    下一篇:asp中提示至少一个参数没有被指定值 解决方法
  • 相关文章
  • 

    © 2016-2020 巨人网络通讯 版权所有

    《增值电信业务经营许可证》 苏ICP备15040257号-8

    ASP常见的保留字整理(变量与表名注意不能用) ASP,常见,的,保留,字,整理,