stuName varchar(50) not null,
stuNo varchar(50) primary key not null,
stuSex char(2) default '男' check(stuSex = '男' or stuSex = '女') not null,
stuAge int check(stuAge between 15 and 50) not null,
stuSeat int identity(1,1) not null,
stuAddress varchar(200) default '地址不详'
)
insert into stuinfo values('张秋丽','s25301','男',18,'北京海淀')
insert into stuinfo values('李斯文','s25303','女',22,'河南洛阳')
insert into stuinfo(stuname,stuno,stusex,stuage) values('李文才','s25302','男',31)
insert into stuinfo values('欧阳俊雄','s25304','男',28,'新疆威武哈')
--drop table stuInfo
create table stuMarks
