Don't use SQL keyword as your feild name of a table

柔情只为你懂 2021-11-02 10:08 230阅读 0赞

Don’t use SQL keyword as your feild name of a table

It will report error when you save a table if you use SQL keyword as your feild name of a table

SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword ‘SET’.

SQL statement: CREATE TABLE X50709X (PRODUCTID VARCHAR(20) NOT NULL DEFAULT ‘’ ,LINENUM INT NOT NULL DEFAULT 0 ,ITEMID VARCHAR(20) NOT NULL DEFAULT ‘’ ,UNITID VARCHAR(10) NOT NULL DEFAULT ‘’ ,QTY NUMERIC(28,12) NOT NULL DEFAULT 0 ,USEFORMULA INT NOT NULL DEFAULT 0 ,FORMULA VARCHAR(50) NOT NULL DEFAULT ‘’ ,SCRAPVAR NUMERIC(28,12) NOT NULL DEFAULT 0 ,SCRAPCONST NUMERIC(28,12) NOT NULL DEFAULT 0 ,COLORMATCHING INT NOT NULL DEFAULT 0 ,SET VARCHAR(10) NOT NULL DEFAULT ‘’ ,DATAAREAID VARCHAR(3) NOT NULL DEFAULT ‘dat’ ,RECVERSION INT NOT NULL DEFAULT 1 ,RECID INT NOT NULL CHECK (RECID <> 0) )

posted on 2010-11-11 17:11 Jacky Xu 阅读( …) 评论( …) 编辑 收藏

转载于:https://www.cnblogs.com/JackyXu1981/archive/2010/11/11/1875053.html

发表评论

表情：
评论列表 （有 0 条评论，230人围观）

还没有评论，来说两句吧...

相关阅读