数据库的创建、插入数据

create database TestSchool --创建数据库TestSchool

create table TblStudent --创建一个学生表TblStudent
(
 tSId int identity(1,1),
 tSName nvarchar(50) not null,  
 tSGender nchar(1),--性别
 tSAddress  nvarchar(50),--地址
    tSPhone  varchar(11),--电话
    tSAge int,
    tSBirthday date,--生日
    tSCardId varchar(10),--学号
    tSClassId nvarchar(50)--班级
)
go
create table TblScore --创建学生成绩表TblScore

(
 tScoreId int identity(1,1) primary key,--成绩id,主键,自动编号
 tSId int not null,  --学生编号
 tEnglish int,--英语成绩
 tMath int --数学成绩
)
go

create table TblTeacher --创建老师表TblTeacher
(
 tTId int identity(1,1) primary key,
 tTName nvarchar(50) not null,
 tTGender nchar(1),--性别
 tTAge int,
 tTSalary money,--工资
 tTBirthday date--生日
)
go

 

 

insert into TblStudent(tSName,tSGender,tSAddress,tSPhone,tSAge,
tSBirthday,tSCardId,tSClassId)
values('易天边',0,'直达',15932024517,19,'1993-07-20','113207074','net班');
insert into TblStudent(tSName,tSGender,tSAddress,tSPhone,tSAge,
tSBirthday,tSCardId,tSClassId)
values('夏天',1,'建设路',15932024518,20,'1992-06-25','113207075','java班');
insert into TblStudent(tSName,tSGender,tSAddress,tSPhone,tSAge,
tSBirthday,tSCardId,tSClassId)
values('田雨希',0,'幸福大街',15932024519,21,'1991-08-26','113207076','php班');
insert into TblStudent(tSName,tSGender,tSAddress,tSPhone,tSAge,
tSBirthday,tSCardId,tSClassId)
values('范范',1,'文化广场南100米74号',15932024510,19,'1993-10-11','113207077','3G班');

 

 

insert into TblScore(tSId,tEnglish,tMath)
values(11,86,94);

insert into TblScore(tSId,tEnglish,tMath)
values(22,79,91);

insert into TblScore(tSId,tEnglish,tMath)
values(33,53,98);

insert into TblScore(tSId,tEnglish,tMath)
values(44,89,66);

insert into TblTeacher(tTName,tTGender,tTAge,tTSalary,tTBirthday)
values('陈维华',0,30,2500,'1982-08-26');
insert into TblTeacher(tTName,tTGender,tTAge,tTSalary,tTBirthday)
values('姚洪波',1,26,3500,'1986-09-27');
insert into TblTeacher(tTName,tTGender,tTAge,tTSalary,tTBirthday)
values('李伟',1,29,4000,'1983-10-28');
insert into TblTeacher(tTName,tTGender,tTAge,tTSalary,tTBirthday)
values('陈红军',1,25,4500,'1987-11-29');