create table roomtype
(typeid varchar(50) not null primary key,
Typename varchar(50) not null,
area Numeric,
bednum tinyint not null check(bednum>0 and bednum<8),
Price numeric default(100),
htelephone varchar(20) default('有'))
insert into roomtype values ('00001','lily',1,5,20,'有')
select * from roomtype
varchar(max) 其max 值为8000,最好设置其字段的最大长度
create table roomtype
(typeid varchar(50) not null primary key,
Typename varchar(50) not null,
area Numeric,
bednum tinyint not null check(bednum>0 and bednum<8),
Price numeric default('100'),
htelephone varchar(15) default('有'))
go
insert into roomtype values('a001','101',101,6,100,'ss');
go