--创建数据库
create database School
on
(
name='School_data',
filename='d:\School_data.mdf',
size=5mb,
maxsize=10mb,
filegrowth=15%
)
log on
(
name='School_log',
filename='d:\School_log.ldf',
maxsize=4mb,
size=2mb,
filegrowth=1mb
)
go
--创建表
create table TblClass
(
cId int identity(1,1) primary key,
cName nvarchar(20) not null,
cDesciption text
)
create table TblStudent
(
sId int identity(1,1) primary key,
sClassId int not null,
sName nvarchar(50) not null,
sAge int not null,
sNo numeric(18,0),
sSex char(2) not null,
sEmail varchar(50)
)
--向TblClass表中插入数据
insert into TblClass ( cName,cDescription ) values (' 高一一班 ',' 快班 ')
insert into TblClass ( cName,cDescription ) values (' 高一二班 ',' 中班 ')
insert into TblClass ( cName,cDescription ) values (' 高一三班 ',' 慢班 ')
insert into TblClass ( cName,cDescription ) values (' 高二一班 ',' 快班 ')
insert into TblClass ( cName,cDescription ) values (' 高二二班 ',' 中班 ')
insert into TblClass ( cName,cDescription ) values (' 高二三班 ',' 慢班 ')
--向TblStudent表中插入数据
insert into TblStudent ( sClassId,sName,sAge,sSex,sNo,sBirthday ) values (1,' 刘备 ',20,' 男 ',123456789012345678,'1987-5-6')
insert into TblStudent ( sClassId,sName,sAge,sSex,sNo,sBirthday ) values (2' 关羽 ',19,' 男 ',123456789012345671,'1988-8-6')
insert into TblStudent ( sClassId,sName,sAge,sSex,sNo,sBirthday ) values (3,' 张飞 ',18,' 男 ',123456789012345672,'1989-5-19')
insert into TblStudent ( sClassId,sName,sAge,sSex,sNo,sBirthday ) values (4,' 曹操 ',22,' 男 ',123456789012345673,'1985-12-6')
insert into TblStudent ( sClassId,sName,sAge,sSex,sNo,sBirthday ) values (5,' 夏侯惇 ',22,' 男 ',123456789012345674,'1985-3-6')
insert intoTblStudent( sClassId,sName,sAge,sSex,sNo,sBirthday ) values (6,' 华佗 ',50,' 男 ',12345678901234565,'1957-1-16')
insert into TblStudent ( sClassId,sName,sAge,sSex,sNo,sBirthday ) values (7,' 甄姬 ',18,' 女 ',12345678901234565,'1989-8-8')