不希望'('参考附近的不正确的语法 [英] Incorrect Syntax Near NOT Expecting '(' Reference
问题描述
创建表empDetails(
EMP_ID int(11)主键NOT NULL,
密码varchar(10)NOT NULL
);
第一表是克里特岛.我得到错误第二张桌子.我正在使用manaement Studio 2008R2.
创建表LEAVE_DETAILS(
EMP_ID int(11)外键NOT NULL,
LeaveEarnedBalance float(2),
LeaveEarnedCredit float(2),
LeaveCasualBalance float(2),
LeaveCasualCredit float(2),
LeaveMaternityBalance float(2),
LeaveMaternityCredit float(2)
);
如何纠正此问题
CREATE TABLE empDetails (
EMP_ID int(11) primary key NOT NULL,
password varchar(10) NOT NULL
);
First tabel is crete. i got error second table. i am using manaement studio 2008R2.
CREATE TABLE LEAVE_DETAILS (
EMP_ID int(11) foreign key NOT NULL,
leaveEarnedBalance float(2) ,
leaveEarnedCredit float(2),
leaveCasualBalance float(2) ,
leaveCasualCredit float(2),
leaveMaternityBalance float(2) ,
leaveMaternityCredit float(2)
);
how to rectify this
推荐答案
尝试此问题
try this
CREATE TABLE LEAVE_DETAILS (
EMP_ID INT NOT NULL,
leaveEarnedBalance float(2) ,
leaveEarnedCredit float(2),
leaveCasualBalance float(2) ,
leaveCasualCredit float(2),
leaveMaternityBalance float(2) ,
leaveMaternityCredit float(2)
);
这篇关于不希望'('参考附近的不正确的语法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!