SQL笔记(一)

create database studentbd2on primary (name=studentbd2,filename='F:\database\student2mdf.mdf',size=5,maxsize=10,filegrowth=10%)log on(name=student2log,filename='F:\database\student2_log.ldf',size=2,maxsize=5,filegrowth=10%)use studentbd2gocreate table 学生表(学号 char(9) not null constraint pk_stuid primary key,姓名 varchar(8) not null constraint unq_stuname unique,性别 bit constraint de_sex default 0,总分 float constraint ck_zf check(总分>=0))create table 课程表(课程号 char(9) not null constraint pk_coursid primary key,课程名 varchar(20) not null constraint unq_coursename unique,学时 int constraint ck_xueshi check(学时>=0),学分 int constraint ck_xuffen check(学分>=0))create table 选课表(学号 char(9) not null constraint fk_student_xk foreign key references 学生表(学号),课程号 char(9)not null constraint fk_course_xk foreign key references 课程表(课程号),成绩 numeric(4,1) constraint ck_chengji check(成绩<=100 and 成绩>=0),constraint pk_xk primary key(学号,课程号))create table 图书表(编号 int identity(1001,1) not null constraint pk_bh primary key,索书号 char(9) not null constraint ubiq_ssh unique,)insert into 图书表 values ('s10101'),('s12212')select * from 图书表