xsgl.sql

原代码详细说明是关于c++方面的希望可以帮助大家使用

--1.建立数据库
create database xsgl
on primary
(
   name='xsda_data',           --主要文件
   filename='f:\xsda_data.mdf',--文件名
   size=1,                     --初始大小
   maxsize=10,                 --最大容量,如果使用UNLIMITED ，不受限
   filegrowth=10               --增加量
),
(
   name='xsda_data1',           --次要文件
   filename='f:\xsda_data1.ndf',--文件名
   size=1,                      --初始大小
   maxsize=10,                  --如果使用UNLIMITED ，不受限
   filegrowth=10                --增加的量,默认单位% ,可是使用M(兆）
)
log on
(
   name='xsda_log',             --日志文件
   filename='f:\xsda_log.ldf',
   size=1,
   maxsize=UNLIMITED ,
   filegrowth=10
)
go

--建立表 
use xsgl
go  
create table student
(
  studID varchar(10)  primary key,--既是标识也是主键约束
  studName varchar(10) not null,--非空约束
  studSex char(2) default('男') check(studSex='男' or studSex='女'),  --检查性约束
  studAddress varchar(40),
  enterScore float
)
go
create table course
(
   courseID varchar(10) primary key,
   courseName varchar(30) not null unique , --唯一性约束
   teacher varchar(10)
)
go
create table score
(
  studID varchar(10) foreign key(studID) references student, 
  courseID varchar(10) foreign key(courseID) references course, 
  score float,
  primary key(studID,courseID)
)
go
insert into student values('05010101','张学军','男','北京',555)
insert into student values('05010102','李红','女','北京',530)
insert into student values('05010103','刘磊','男',' 大连',490)
insert into student values('05010104','韩云霞','女','北京',590)
insert into student values('05010105','杨大智','男','大连',520)
insert into student values('05010106','刘占江','男','北京',540)
insert into student values('05010107','赵昆','男','天津',610)
Insert into course values('050101','Java','yang')
insert into course values('050102','C','wang')
insert into course values('050103','SQL','zhang')
insert into course values('050104','ASP','huang')
insert into score values('05010101','050101',80)
insert into score values('05010101','050102',70)
insert into score values('05010101','050103',86)
insert into score values('05010101','050104',88)

insert into score values('05010102','050101',70)
insert into score values('05010102','050102',77)
insert into score values('05010102','050103',86)
insert into score values('05010102','050104',98)

insert into score values('05010103','050101',70)
insert into score values('05010103','050102',70)
insert into score values('05010103','050103',76)
insert into score values('05010103','050104',88)

insert into score values('05010104','050101',80)
insert into score values('05010104','050102',70)
insert into score values('05010104','050103',86)
insert into score values('05010104','050104',88)
create table studentPhoto
(
    studID varchar(10)  primary key,--既是标识也是主键约束
    studName varchar(10) not null,--非空约束
    studPhoto image
)