VALUE -->>>values 呵呵,这个也不对吧~ 建议:如果SQL语句执行失败,先把SQL语句response出来,然后把它拿到查询分析器里面看可不可以顺利执行。如果是SQL语法问题,一般都可以这么解决
建议把sql语句放到查询器中看看,把变色的关键字用[]扩起来
你有了SQL的保留字!!加上中括号! 以下列出A到c的SQL保留字! AABSOLUTE ANY ADD ARE ADMINDB AS ALL ASC Alphanumeric — See TEXT ASSERTION ALTER AUTHORIZATION ALTER TABLE AUTOINCREMENT — See COUNTER And Avg AS B-CBEGIN COLLATION Between COLUMN BINARY COMMIT BIT COMP, COMPRESSION BIT_LENGTH CONNECT BOOLEAN — See BIT CONNECTION BOTH CONSTRAINT, CONSTRAINTS BY CONTAINER BYTE CONTAINS CASCADE CONVERT CATALOG Count CHAR, CHARACTER — See TEXT COUNTER CHAR_LENGTH CREATE CHARACTER_LENGTH CURRENCY CHECK CURRENT_DATE CLOSE CURRENT_TIME CLUSTERED CURRENT_TIMESTAMP COALESCE CURRENT_USER COLLATE CURSOR
呵呵,这个也不对吧~
建议:如果SQL语句执行失败,先把SQL语句response出来,然后把它拿到查询分析器里面看可不可以顺利执行。如果是SQL语法问题,一般都可以这么解决
以下列出A到c的SQL保留字!
AABSOLUTE ANY
ADD ARE
ADMINDB AS
ALL ASC
Alphanumeric — See TEXT ASSERTION
ALTER AUTHORIZATION
ALTER TABLE AUTOINCREMENT — See COUNTER
And Avg
AS
B-CBEGIN COLLATION
Between COLUMN
BINARY COMMIT
BIT COMP, COMPRESSION
BIT_LENGTH CONNECT
BOOLEAN — See BIT CONNECTION
BOTH CONSTRAINT, CONSTRAINTS
BY CONTAINER
BYTE CONTAINS
CASCADE CONVERT
CATALOG Count
CHAR, CHARACTER — See TEXT COUNTER
CHAR_LENGTH CREATE
CHARACTER_LENGTH CURRENCY
CHECK CURRENT_DATE
CLOSE CURRENT_TIME
CLUSTERED CURRENT_TIMESTAMP
COALESCE CURRENT_USER
COLLATE CURSOR