创建一个表,有错误不知道怎么改,大家帮忙改一下,谢了!!! - 编程论坛

czyzhuo2010-04-02 09:48

CREATE TABLE room
(
    room_no NVARCHAR(30) COLLATE chinese_prc_ci_as NOT NULL,
    cat NVARCHAR(30) COLLATE chinese_prc_ci_as NOT NULL,
    floot NVARCHAR(30) COLLATE chinese_prc_ci_as NOT NULL CONSTRAINT DF_room_floot DEFAULT 1,
    price FLOAT NOT NULL CONSTRAINT DF_room_price DEFAULT 120,
    people_num INT NOT NULL CONSTRAINT DF_room_people_num DEFAULT 1,
    ishave_people INT NOT NULL CONSTRAINT DF_room_ishave_people DEFAULT 0,
    remark NVARCHAR(250) COLLATE chinese_prc_ci_as NULL
    CONSTRAINT PK_room PRIMARY KEY CLUSTERED
    (
        room_no ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

单价float not null  constraint df_酒店房间_单价 default((120)),        单价和float 之间要有空格
with(ignore_dup_key=off) on primary  改成   with(ignore_dup_key=off) on [primary]

czyzhuo2010-04-02 09:53

constraint pk_酒店房间 primary key clustered
( 房间 asc
)with(ignore_dup_key=off) on primary

这里的”房间“不是表里的字段，是不正确的

下面这样写，你参考一下（说明一点，名字一般用英文比较好。）
CREATE TABLE 酒店房间
(
    房号 NVARCHAR(30) COLLATE chinese_prc_ci_as NOT NULL,
    类别 NVARCHAR(30) COLLATE chinese_prc_ci_as NOT NULL,
    楼层 NVARCHAR(30) COLLATE chinese_prc_ci_as NOT NULL CONSTRAINT df_酒店房间_楼层 DEFAULT 1,
    单价 FLOAT NOT NULL CONSTRAINT df_酒店房间_单价 DEFAULT 120,
    可容纳人数 INT NOT NULL CONSTRAINT df_酒店房间_可容纳人数 DEFAULT 1,
    已入住人数 INT NOT NULL CONSTRAINT df_酒店房间_已入住人数 DEFAULT 0,
    说明 NVARCHAR(250) COLLATE chinese_prc_ci_as NULL
    CONSTRAINT pk_酒店房间 PRIMARY KEY CLUSTERED
    (
        房号 ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]