建立表格示例的SQL表及插入数据语法

最新推荐文章于 2024-03-25 09:15:03 发布

Jane007123

最新推荐文章于 2024-03-25 09:15:03 发布

阅读量644

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL Server

本文链接：https://blog.youkuaiyun.com/jane007123/article/details/38342329

SQL Server 专栏收录该内容

25 篇文章

订阅专栏

本文介绍了一个简单的学生课程成绩管理系统的设计，包括学生表、课程表、教师表及成绩表的创建与填充过程。通过这些表格可以记录学生的个人信息、所修课程及其成绩等数据。

/*create table Student(S# varchar(10),Sname nvarchar(10),Sage datetime,Ssex nvarchar(10))
insert into Student values ('01','赵雷','1990-01-01','男')
insert into Student values ('02','钱电','1990-12-21','男')
insert into Student values ('03','孙风','1990-05-20','男')
insert into Student values ('04','李云','1990-08-06','男')
insert into Student values ('05','周梅','1990-04-01','女')
insert into Student values ('06','吴兰','1990-03-01','女')
insert into Student values ('07','郑竹','1990-07-01','女')
insert into Student values ('08','王菊','1990-01-07','女

create table Course (C# varchar(10),Cname nvarchar(20),T# varchar(10))
insert into Course values ('01','语文','02')
insert into Course values ('02','数学','01')
insert into Course values ('03','英语','03')

create table Teacher (T# varchar(10),Tname varchar(10))
insert into Teacher values ('01','张三')
insert into Teacher values ('02','李四')
insert into Teacher values ('03','王五')

create Table SC (S# varchar(10),C# varchar(10),score decimal(18,1))
insert into SC values('01','01',80)
insert into SC values('01','02',90)
insert into SC values('01','03',99)
insert into SC values('02','01',70)
insert into SC values('02','02',60)
insert into SC values('02','03',80)
insert into SC values('03','01',80)
insert into SC values('03','01',80)
insert into SC values('03','01',80)
insert into SC values('04','01',50)
insert into SC values('04','01',30)
insert into SC values('04','01',20)
insert into SC values('05','01',76)
insert into SC values('05','01',87)
insert into SC values('06','01',31)
insert into SC values('06','01',34)
insert into SC values('07','01',89)
insert into SC values('07','01',98)
*/