使用 SQL 语句创建 School 数据库（包括参数）、 TblClass 表、 TblStudent 表。

--创建数据库

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')