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

来源：互联网发布：武汉人工智能创业公司编辑：程序博客网时间：2024/05/22 03: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)
*/

0 0