Question

我想做一个“网站购物”系统，估计MS-SQLServer数据库不对，老是导致“关键字‘user’附近有语法错误”求

表user(用户)：* u_id u_name u_pwd u_question u_answer u_tel u_address
表product（产品）：* p_id p_t_id p_name p_price p_img p_hits p_date p_con
表type（产品类别）； * t_id t_name
表message（用户帮助）；*m_id m_u_id m_question m_answer m_date
表news（新闻）: * n_id n_nt_id n_title n_text n_date n_date
表ntype（新闻类别）: *nt_id nt_name
表order（订单）: * o_id o_u_id o_sub o_grand o_date
表details（详细）：*d_id d_o_id d_p_id d_unit d_quantify
表collection（用户产品收藏）: * c_id c_u_id c_p_id c_date c_con
表comments（用户产品评论）:* co_id co_u_id co_p_id co_con co_date
表changinfo（用户管理员交流）:*ch_id ch_u_id ch_title ch_text ch_answer ch_date
表admin（管理员）：*a_id a_name a_pwd

附注：带“ * ”为主键，其他的详细内容见图
还有就是比如说news和ntype有关系，则dbo.news里面的n_nt_id 对应dbo.ntype里面的nt_id，其他类似！关系图的联系关系见附图！
有大虾可以帮助我的嘛？小弟不胜感激！
还有补充问一个，就是视图什么的会导致“关键字‘user’附近有语法错误”的问题吗？以及解决办法是什么？谢谢啦！

Answer 1

user 在SQL里面是关键词 所以不把他当成表名，而是系统关键字 所以把他换个名字就OK

追问

SQL里面的关键字还有哪些啊？能帮我简单的列举一点吗？

追答

不知你改好没有

ADD
EXCEPT
PERCENT
ALL
EXEC
PLAN
ALTER
EXECUTE
PRECISION
AND
EXISTS
PRIMARY
ANY
EXIT
PRINT
AS
FETCH
PROC
ASC
FILE
PROCEDURE
AUTHORIZATION
FILLFACTOR
PUBLIC
BACKUP
FOR
RAISERROR
BEGIN
FOREIGN
READ
BETWEEN
FREETEXT
READTEXT
BREAK
FREETEXTTABLE
RECONFIGURE
BROWSE
FROM
REFERENCES
BULK
FULL
REPLICATION
BY
FUNCTION
RESTORE
CASCADE
GOTO
RESTRICT
CASE
GRANT
RETURN
CHECK
GROUP
REVOKE
CHECKPOINT
HAVING
RIGHT
CLOSE
HOLDLOCK
ROLLBACK
CLUSTERED
IDENTITY
ROWCOUNT
COALESCE
IDENTITY_INSERT
ROWGUIDCOL
COLLATE
IDENTITYCOL
RULE
COLUMN
IF
SAVE
COMMIT
IN
SCHEMA
COMPUTE
INDEX
SELECT
CONSTRAINT
INNER
SESSION_USER
CONTAINS
INSERT
SET
CONTAINSTABLE
INTERSECT
SETUSER
CONTINUE
INTO
SHUTDOWN
CONVERT
IS
SOME
CREATE
JOIN
STATISTICS
CROSS
KEY
SYSTEM_USER
CURRENT
KILL
TABLE
CURRENT_DATE
LEFT
TEXTSIZE
CURRENT_TIME
LIKE
THEN
CURRENT_TIMESTAMP
LINENO
TO
CURRENT_USER
LOAD
TOP
CURSOR
NATIONAL
TRAN
DATABASE
NOCHECK
TRANSACTION
DBCC
NONCLUSTERED
TRIGGER
DEALLOCATE
NOT
TRUNCATE
DECLARE
NULL
TSEQUAL
DEFAULT
NULLIF
UNION
DELETE
OF
UNIQUE
DENY
OFF
UPDATE
DESC
OFFSETS
UPDATETEXT
DISK
ON
USE
DISTINCT
OPEN
USER
DISTRIBUTED
OPENDATASOURCE
VALUES
DOUBLE
OPENQUERY
VARYING
DROP
OPENROWSET
VIEW
DUMMY
OPENXML
WAITFOR
DUMP
OPTION
WHEN
ELSE
OR
WHERE
END
ORDER
WHILE
ERRLVL
OUTER
WITH
ESCAPE
OVER
WRITETEXT