版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
seIect
USEstudent
GO
SELECTstudJd,name,birthday,gender,mark
FROMstud_info
WHEREnameLIKEN'郑」
USEstudent
GO
SELECTteacher_id,name,tech_titie,salary
FROMteacherjnfo
WHEREtech_tit1eIN(N'助教W讲师TW副专家,)
USEstudent
GO
SELECTAVG(grade)FROMstud_gradeWHEREcourse_id="
USEstudent
GO
SELECTstudjd学号,name姓名,year(getdate())—year(birthday)年
龄,birthday出生日期
FROMstud_info
WHEREgender=N'男'
ORDERBYbirthdayASC
SEstudent
GO
SELECTsubstring(stud_id,5,2)专业编号,avg(mark)平均入学成绩
FROMstud_info
WHEREsubstring(stud_id,3»2)='01'
GROUPBYsubstring(stud_id,5,2)
USEstudent
G0
SELECTtech_titie,avg(age)
FROMteacher_info
GROUPBYtech_title
HAVINGtech_title=Nz讲师,
USEstudent
GO
SELECTtech_tit1e,salary
FROMteacher_info
WHEREtech_title=N讲师,
ORDERBYtech_tit1e
COMPUTEsum(salary)
/*查询每个学生的学号、姓名、邮政编码等基本信息及其所选课程的成绩*/
USEstudent
GO
SELECTstud_info.stud_id,stud_zstudjnfo.zipcode,s
tud_grade.grade
FROMstud_info,stud_grade
WHEREstudjnfo.studjd=stud_grade.studJd
/*在FROM子句中定义内连接查询每门课程名称及其该门课的任课老师的姓名、
编号7
USEstudent
GO
SELECTteacher_info.teacher_id,,1essonjnf
o.course_name
FROMIesson_infoINNERJ0INteacher_info
ON(Iessonjnfo.course_id=teacher__info.coursejd)
/*在stud_info与stud_grade中按学号stud—id进行等值连接,
以查询所有参与考试的学生基本信息和成绩分数。*/
USEstudent
GO
SELECT*
FROMstud_infoINNERJOINstud_grade
ONstud_info.stud_id=stud_grade.studjd
0RDERBYstud_info.stud_id
/*stud_info和stud_grade采用自然连接以限制结果集的冗余列数据*/
USEstudent
GO
SELECTstud_grade.*,stud_info,telcodezstudjnfo.mark
FROMstud_gradeINNERJOINstudJnfo
ONstud_grade.studjd=stud_info.studjd
ORDERBYstud_grade.stud—id
USEstudent
GO
INSERTINTOstudJnfo-为了说明方便,先在学生信息表中插入一条新记录
VALUES。,N'王一明70前夕1986,男,,N'甘肃省兰州市
“/590000',573)
SELECTstud_info.stud_id,studJ,stud_grade.course_id
FROMstud_infoLEFT0UTERJOINstud_grade
ONstudjnfo.stud_id=stud_grade.stud—id
0RDERBYstudjnfo.stud_id,,stud_grade.course_id
/*学生信息表stud_info右外连接学生成绩表stud_grade*/
USEstudent
GO
SELECTstud_info.studjd,,stud_grade.course_id
FROMstud_gradeRIGHTOUTERJ0INstud_info
ONstudjnfo.stud_id=stud_grade.stud_id
ORDERBYstudJnfo.stud_id,stud_,stud_grade.courseJd
/*教师信息表teachejinfo全外连接课程信息表1essonjnfo*/
USEstudent
GO
SELECT1essonjnfo.course_name,teacher_,teacher_
info,teacher—id
FROMIesson_infoFULLOUTERJOINteacher_info
ONIessonjnfo.course_id=teacherjnfo.coursejd
ORDERBY1essonJnfo.course_namezteacherJ,teacher
_info.teacher_id
/*查询学生成绩表stud_grade中与学号为“”的学生所学的课程相同的学生
的学号、姓名、课程号、成绩*/
USEstudent
GO
SELECTa.studjd,,a.course_id,a.grade
FROMstud_gradea,stud_gradeb
WHEREa.course_id=b.course_idANDa.stud_id<>"ANDb.stud_id=u
/*查询与学号为“”的学生同在计算机应用技术专业
(学号stud_id中第5位和第6位为“专业编号”)学习的所有学生的学号、姓名、
性别及电话号码*/
USEstudent
GO
SELECTstudjd,name,gender,te1code
FROMstudJnfo
WHEREsubstring(stud_id,5,2)=(SELECTsubstring(stud_id,5,
2)
FROMstudinfo
WHEREstudid=")
/*在学生成绩表中查询课程类型为“考试”的学生学号、姓名、成绩*/
USEstudent
GO
SELECTstud_id,namezgrade
FROMstud_grade
WHERECourse_idIN(SELECTCOUrsejd
FROM1essonJnfo
WHEREcourse_type=NZ考试')
/*查询课程号为的多媒体技术这门课的成绩在80至89分的学生的学号、姓
名*/
USEstudent
GO
SELECTStudjd,name
FROMstudjnfo
WHEREEXISTS(SELECT*FROMstud_grade
WHEREstud_grade.stud_id=stud_info.studjdAND
(gradeBETWEEN80AND89)ANDcourse_id=")
/*查询所学专业同为“计算机控制技术”或年龄为21岁的所有学生的姓名*/
USEstudent
GO
SELECTstud_id,nameFROMstudjnfoWHEREsubstring(stud_id,5,
2)='03'
UNION
SELECTstud_id,nameFROMstud_infoWHEREDATEDIFF(year,bir
thday,getdate())=21
2、STUDENT
createdatabasestudent
go
USEstudent
GO
CREATETABLEteacher_info
(teacherjdCHAR(6)NOTNULL,
nameNVARCHAR⑷NOTNULL,
genderNCHAR(1),
ageINTz
tech_titIeNVARCHAR(5),
telephoneVARCHAR(12),
salaryDECIMAL(7,2),
course_idCHAR(10)
);
USEstudent
GO
CREATETABLEteach_scheduIe
(courseJdCHAR(10)NOTNULL,
course_timeDATETIME,
course_weekCHAR(2),
roomjdCHAR(6),
deptcodeCHAR(2),
teacher_idCHAR(6)
)
USEstudent
GO
CREATETABLEstudjnfo
(stud_idCHAR(10)NOTNULL,
nameNVARCHAR(4)NOTNULL,
birthdayDATETIME,
genderNCHAR(l),
addressNVARCHAR(20),
teleodeCHAR(12),
zipcodeCHAR(6),
markDECIMAL(3,0)
)
USEstudent
GO
CREATETABLEstud_grade
(stud_idCHAR(IO)NOTNULL,
nameNVARCHAR(4)NOTNULL,
courseJdCHAR(IO),
gradeDECIMAL(4,1)
USEstudent
GO
CREATETABLEstaffroom_info
(
jysh_idCHAR(4)notnul1,
jysh_nameNVARCHAR(10),
jysh_typeNCHAR⑵,
jyshJeaderNVARCHAR(4)
)
USEstudent
GO
CREATETABLEspecialty_code
(
speccodeCHAR(6),
specnameNVARCHAR(10)
)
USEstudent
GO
CREATETABLEIesson_info
(coursejdCHAR(10)NOTNULL,
course_nameNVARCHAR(12)NOTNULL,
course_typeNCHAR(2)NOTNULL,
course_timeINTNOTNULL,
course_markDECIMAL(3,1)
)
USEstudent
GO
CREATETABLEdept_code
(
deptcodeCHAR(2),
deptnameNVARCHAR(IO)
)
USEstudent
G0
CREATETABLEclassroom__info
(roomjdCHAR(6)NOTNULL,
room__nameNVARCHAR⑻,
room_typeNVARCHAR⑸,
room_deviceNVARCHAR(10),
room_sizeDECIMAL(3,0)
)
USEstudent
GO
INSERTINTOteacherjnfoVALUES('010101',N'刘娜',N'女',34,N'讲师
,,1418/');
INSERTINTOteacherjnfoVALUES('0101O6',N'王吉林',N'男',32,N'
讲师,,",1418,'');
INSERTINTOteacher_infoVALUES('0101O2',N'邵云鹏',N'男',45,N'
专家:71458,");
INSERTINTOteacher_infoVALUES('O10104',N'赵一欧',N'女',26,N'
助教,,",1380,");
INSERTINTOteacher_infoVALUES(Z010105',N'王小悦',N'女',35,N'
讲师,,",1448,");
INSERTINTOteacher_infoVALUES(,010103',N孙乐多N,男,,27,N'
助教','’,1380,'');
USEstudent
GO
INSERTINTOteach_scheduleVALUES(''08-30-2023',‘15','1207
03z,'01';010104');
INSERTINT0teach_scheduleVALUES(";08-30-2023'15'120704','01'/
010101');
INSERTINTOteach_scheduleVALUES08-30-2023'z'13','120705';0
1,,;010106');
INSERTINTOteach_scheduleVALUES('','08-30-202
3','10','120706'0l','010105');
INSERTINTOteach_schedu1eVALUES(",'08-30-2023','19';120707';01
','010102;);
INSERTINTOteach_schedu1eVALUES(",'08-30-2023'/14','120708','0
1;,'010103z);
USEstudent
GO
INSERTINTO"STUDJNFO"("STUD_ID","NAME","BIRTHDAY","GENDE
R","ADDRESS","TELCODE","ZIPCODE","MARK")
VALUES(",N'M'/12-05-1986男',N'北京市海淀区100080,,560);
INSERTINTO"STUD_INFO"("STUDJD","NAME","BIRTHDAY","GE
NDER","ADDRESS","TELCODE","ZIPCODE","MARK")
VALUES(",N,赵明'/08-06-1986',N'男',N'上海市浦东区20230056
0);
INSERTINTO"STUD_INFO"("STUDJD","NAME","BIRTH
DAY","GENDER","ADDRESS","TELCODE","ZIPCODE","MARK")
VALUES(,N'王刚'/01—02-1986,,N'男,,N'天津市南开区广,,30000(T,560);
INSERTINTO"STUDJNFO"("STUD_ID","NAME","BIRTHDAY"/GENDER",
"ADDRESS","TELCODE","ZIPCODE","MARK")
VALUESJ',N'陈红,,'10-25-1986',M女',N'武汉市汉口区'430000',560);
INSERTINTO"STUD_INFO"("STUD_ID","NAME","BIRTHDAY","
GENDER","ADDRESS","TELCODE","ZIPCODE","MARK")
VALUES(",W孙强','06-07-1986',N,男',N'重庆市沙坪坝=",400000',560);
INSERTINTO"STUDJNFO"("STUD_ID","NAME","BIRTHDAY",
"GENDER"/'ADDRESS","TELCODE","ZIPCODE","MARK")
VALUES(",N'李伟','09-01-1986',N7男’,N'北京市大兴县102600,,
560);
INSERTINTO"STUDJNFO"("STUDJD","NAME","BIRTHDAY","G
ENDER","ADDRESS","TELCODE","ZIPCODE","MARK")
VALUES(",N'钱昆'「12-06-1986',N'男',N广州市海珠区',",'510000',560);
INSERTINTO"STUDJNFO"("STUDJD","NAME","BIRTHDAY","GENDER",
"ADDRESS","TELCODE","ZIPCODE","MARK")
VALUES("N郑芳','08—09-1986)*女',N'江苏省南京市',",'210000,,
560);
INSERTINTO"STUD_lNFO"("STUDJD","NAME","BIR
THDAY","GENDER","ADDRESS"TELCODE","ZlPCODE","MARK")
VALUESC,N'袁飞'03-11-1986',N'^',N,湖南省长沙县410000',560);
INSERTINTO"STUD_INFO"("STUDJD","NAME","BIRTHDAY","GENDE
R","ADDRESS"TELCODE","ZIPCODE","MARK")
VALUES(",N'?L^','O5-31-1986',N[男,,N'云南省昆明市',",'650000',600);
USEstudent
GO
INSERTINTOstud_gradeVALUES(",N'张源,90);
INSERTINTOstud_gradeVALUES(',,N'赵明,89);
INSERTINTOstud_gradeVALUES(",N'王刚',",87);
INSERTINTOstudgradeVALUES(",N‘陈红','',91);
INSERTINTOstud_gradeVALUES('',N'孙强83);
INSERTINTOstud_gradeVALUES(",NZ李伟',",86);
INSERTINTOstud_grade丫人|_11£$("四钱昆',”,78卜
INSERTINTOstud_gradeVALUES(",W郑芳95):
INSERTINTOstud_gradeVALUES('',N'袁飞',",95);
INSERTINTOstud_gradeVALUESC',NZ孔荣',",83);
INSERTINTOstudgradeVALUES(",M张军',",84);
USEstudent
GO
INSERTINTOstaffroomjnfoVALUES(,0101',N,计算机应用,,N1专业,,
N'王二毛');
INSERTINTOstaffroom_infoVALUES('0102',Nz计算机网络,,N'专业
N,李四冲');
INSERTINTOstaffroom_infoVALUES('01O3',N'计算机软件',N,专业,,
N'赵一生');
INSERTINTOstaffroom_infoVALUES('0104,,N'计算机管理,,N'专业',N'
汪三洋');
USEstudent
GO
INSERTINTOspecialty_codeVALUES('04010l',N'计算机应用技术,);
INSERTINTOspecialty_codeVALUES('040102',N计算机网络技术');
INSERTINTOspecialty_codeVALUES('040103',N'计算机控制技术,);
INSERTINTOspecialty_codeVALUES('040104',N'多媒体技术');
INSERTINTOspecialty_codeVALUES('040105',N'计算机软件技术,);
INSERTINTOspecialty_codeVALUES(z040106',N'计算机通信技术');
INSERTINTOspecialty,codeVALUES('040107',N'计算机管理技术');
USEstudent
GO
INSERTINTOIesson_infoVALUES(",N,计算机导论',N'考察',30,1.5);
INSERTINTOlesson_inf0VALUES(",N'Java程序设计',N'考试',60,3.5);
INSERTINTOIes5。皿11%丫人1>1^5(,,,1'4微型计算机原理加考试',60,3.5);
INSERTINTOlesson_infoVALUES(",N'IT市场营销,,N,考察',30,1.5);
INSERTINTOIesson_infoVALUES('',N'网络互联设备与配置',N'考
察',60,2.0);
INSERTINTOIessonjnfoVALUES(",N'多媒体技术',N'考察',60,3.0);
USEstudent
GO
INSERTINTOdept_codeVALUES('0l',N'计算机工程系,);
INSERTINTOdept_codeVALUES('02',N'管理工程系');
INSERTINTOdept_codeVALUES(703',N'机电工程系,);
INSERTINTOdept_codeVALUES('04',Nz食品工程系');
INSERTINTOdept_codeVALUES('05',N'轻化工程系');
INSERTINTOdept_codeVALUES-06',N'通信工程系');
INSERTINTOdept_codeVALUES(,07,,N,外语工程系,);
USEstudent
GO
INSERTINTOclassroomjnfoVALUES(120703',N微机组装与维护TN'实训'
微机、投影仪',40);
INSERTINTOclassroom_infoVALUES-120704',N'计算机网络',N'
实验',N'互换机、路由器等',40);
INSERTINTOclassroomjnfoVALUES('120705数据库',N'计算
机机房'N微机、投影仪',60);
INSERTINTOclassroom_infoVALUES('120706',N'软件设计',N'计算机机房',N'
微机、投影仪',60);
INSERTINTOclassroomjnfoVALUES('12O707',N多媒体',N,计算机机房
W微机、投影仪',60);
INSERTINTOclassroom_infoVALUES(,120708',N'',N'普通',N'白板、
投影仪,,120);
3、第五章教学案例
/5.1*查询所有课程的具体信息。T-SQL语句:*/
USEstudent
GO
SELECT*FROM1esson__info
/5.2*在学生基本信息表中查询所有女生的学号、姓名、出生日期的语句:*/
USEstudent
GO
SELECTstud—id学号,nameAS姓名,出生日期二birthday
FROMstud_info
WHEREgender二N‘女'
3*查询学生的学号、姓名、考试成绩的语句:*/
USEstudent
GO
SELECTstud_info.stud_id,stud_,stud_grade.grade
FROMstud_info,stud_grade
WHEREstud_info.stud_id=stud_grade.stud_id
/5.4*将学生的学号、姓名、性别的查询结果作为新建临时表的语句:*/
USEstudent
GO
SELECTstudjd,name,gender
INTOnew_stud_info
FROMstud_info
WHEREgender=N'男'
/*5.5查询性别为“女”的学生的姓名、电话、地址和邮编的语句:*/
USEstudent
GO
SELECTname,address,telcode,zipcode
FROMstud_info
WHEREgender二N'女'
/*5.6列出姓“郑”、姓名为两个汉字的学生学号、姓名,性别,入学成绩的语句:
*/
USEstudent
GO
SELECTstud_id,name,birthday,genderzmark
FROMstud_info
WHEREnameLIKEN'郑」
/*5.7查询教师职称为“助教”,或为“讲师”,或为“副专家”的教师
编号、姓名、职称及工资的语句:*/
USEstudent
GO
SELECTteacher__id,name,tech__tit1e,sa1ary
FR0Mteacher_info
WHEREtechJitIeIN(N'助教',N'讲师',N,副专家')
/*5.8求“Java程序设计”课程平均成绩的语句:*/
USEstudent
GO
SELECTAVG(grade)FROMstud_gradeWHEREcourse_id="
/*5.9查询所有男生学号、姓名和年龄,并按出生日期进行排列(升序)的语句:*/
USEstudent
GO
SELECTstud_id学号,name姓名,year(getdate())-year(birthday)年龄,
birthday出生日期
FROMstud_info
WHEREgender二N'男'
ORDERBYbirthdayASC
/*5.10记录计算机工程系各个专业的学生的平均入学成绩的语句:*/
USEstudent
GO
SELECTsubstring(stud_id,5,2)专业编号,avg(mark)平均入学成绩
FROMstudjnfo
WHEREsubstring(stud_idz3»2)='01'
GROUPBYsubstring(stud_id,5,2)
/*5.11在教师信息表中,按职称分组记录“讲师”的平均年龄的语句:*/
USEstudent
GO
SELECTtech_title,avg(age)
FROMteacherjnfo
GROUPBYtech_tit1e
HAVINGtech_title=N'讲师'
/*5.12对teacherjnfo中职称为“讲师”的工资,生成汇总行和明细行的语句:
*/
USEstudent
GO
SELECTtech_title,sa1ary
FROMteacherjnfo
WHEREtech_titie=N,讲师'
ORDERBYtechjitIe
COMPUTEsum(salary)
/*5.13查询每个学生的学号、姓名、邮政编码等基本信息及其所选课程的成绩
*/
USEstudent
GO
SELECTstud_info.studjd,stud_,studjnfo.zipcode,stud_gr
ade.grade
FROMstudjnfo,stud_grade
WHEREstudjnfo.stud_id=stud_grade.studjd
/*5.14在FROM子句中定义内连接查询每门课程名称及其该门课的任课老师
的姓名、编号*/
USEstudent
GO
SELECTteacher_info.teacherjd,teacher_,lesson_inf
o.course_name
FROMlessonjnfoINNERJOINteacherjnfo
ON(lesson_info,courseJd=teacherJnfo.coursejd)
/*5.15在studJnfo与stud_grade中按学号stud_id进行等值连接,
以查询所有参与考试的学生基本信息和成绩分数。*/
USEstudent
GO
SELECT*
FROMstud_infoINNERJOINstud_grade
ONstudjnfo.stud_id=stud_grade.stud_id
ORDERBYstud_info.stud—id
/*5.16stud_info和stud_grade采用自然连接以限制结果集的冗余列数据*/
USEstudent
GO
SELECTstud_grade.*,studjnfo.telcode,studjnfo.mark
FROMstud_gfadeINNERJOINstud_info
0Nstud_grade,stud_id=stud_info.stud_id
0RDERBYstud_grade.stud_id
/*5.17学生成绩表stud_grade左外连接学生信息表stud_info*/
USEstudent
GO
INSERTINTOstudjnfo-为了说明方便,先在学生信息表中插入一条新记录
VALUES^N王一明)03/0夕1986TN'男'N甘肃省兰州市:
";590000\573)
SELECTstudjnfo.stud_id,stud_,stud_grade.course_id
FROMstudJnfoLEFTOUTERJOINstud_grade
0Nstud_info.studjd=stud_grade.stud—id
ORDERBYstud_info.stud_id,stud_info,name,stud_grade.course_id
/*5.18学生信息表stud_info右外连接学生成绩表stud_grade*/
USEstudent
GO
SELECTstud_info.stud_id,,stud_grade.coursejd
FROMstud_gradeRIGHTOUTERJOINstudjnfo
ONstudjnfo.stud_id=stud_grade.stud—id
0RDERBYstud_info.stud_id,stud_info,name,stud_grade.cour
se_id
/*5.19教师信息表teacher_info全外连接课程信息表lesson_info*/
USEstudent
GO
SELECTlesson_info.course__name,teacher_,teacherj
nfo.teacher—id
FROMlesson__infoFULLOUTERJOINteacherjnfo
ONIesson_info.course_id=teacher_info.course_id
ORDERBY1esson_info.course_name,teacher_,te
acher_info,teacherjd
/*5.20查询学生成绩表stud_grade中与学号为的学生所学的课程相同
的学生
的学号、姓名、课程号、成绩*/
USEstudent
GO
SELECTa.stud_id,,a.course_id,a.grade
FROMstud_gradea,stud_gradeb
WHEREa.course_jd=b.course_idANDa.stud_id<>'zANDb.s
tudjd=z'
/*5.21查询与学号为“”的学生同在计算机应用技术专业
(学号stud_id中第5位和第6位为“专业编号”)学习的所有学生的学号、姓
名、性别及电话号码*/
USEstudent
GO
SELECTstud_id,name,gender;telcode
FROMstud_info
WHEREsubstring(stud—id,5,2)=(SELECTsubstring(stud_id,5,2)
FROMstud_info
WHEREstud_id=")
/*5.22在学生成绩表中查询课程类型为“考试”的学生学号、姓名、成绩*/
USEstudent
GO
SELECTstud_id,name,grade
FROMstud_grade
WHEREcourse_idIN(SELECTcourseJd
FROMlessonjnfo
WHEREcourse_type=N'考试')
/*5.23查询课程号为“”的多媒体技术这门课的成绩在80至89分的学生的学
号、姓名*/
USEstudent
GO
SELECTstud_id,name
FROMstud_info
WHEREEXISTS(SELECT*FROMstud_grade
WHEREstud_grade.stud_id=stud—i
nfo.studjdAND
(gradeBETWEEN80AND89)ANDcours
e_id=")
/*5.24查询所学专业同为“计算机控制技术”或年龄为21岁的所有学生的姓
名*/
USEstudent
GO
SELECTstud_id,nameFROMstud_infoWHEREsubstring(stud_i
d,5,2)="03'
UNION
SELECTstud_id,nameFROMstudjnfoWHEREDATEDIFF(year,bir
thday,getdate())=21
4、第6章案例
/*6.1针对表stud_info创建一个简朴视图*/
USEstudent
GO
CREATEVIEWstud_view2
AS
SELECTstudJdzname,address,telcode,zipcode
FROMstud_info
select*fromstud_view2
/*6.2使用WITHENCRYPTION加密选项为表stud_inf。创建视图火/
USEstudent
GO
/*查看stud_info表中的所有数据。*/
SELECT*FROMStudjnfo
GO
/*基于stud_info,创建视图stud_view3。*/
CREATEVIEWStud_view3
WITHENCRYPTI0N
AS
SELECTstudidas学号,nameas姓名,addressas地址,
telcodeas电话号码,zipcodeas邮政编码
FROMstud_info
WHEREmark>=560
GO
sp_he1ptextstud_view3
sp_helptextstud_view2
/*查看新建视图stud_view3中的所有数据。*/
SELECT*FROMstud_view3
1*63建立计算机系(学号第3-4位为“01”)学生的视图,
并规定进行修改和插入操作时仍需保证视图只有计算机系的学生7
CREATEVIEWstud_computer
AS
SELECTstud_id,name,gender
FROMstud_info
WHEREsubstring(stud_idz3/2)='01'
WITHCHECK0PTION
SELECT*FROMstud_computer
/*6.4建立课室(c1assroom_info)^教师(teacher_info)>课程(lesson_
info)>课程安排表(teach_schedule)
互相对照的视图(schedu1e_view)"/
USEStudent
GO
CREATEVIEWschedule_view
AS
SELECTlesson.course_name,,
classroom.room_namezscheduIe.course_week,
schedu1e.course__time,schedule,courseJd
FROMclassroom_infoclassroom,teacher_infoteacher,
1essonjnfo1esson,teach_scheduleschedu1e
WHEREc1assroom.room_id=schedule.room_id
ANDteacher.teacher_id=schedule.teacher_id
ANDlesson.course_id=schedu1e.coursejd
SELECT*FROMschedule__view
/*6.5修改视图stud_view2定义*/
USEstudent
G0
/*显示修改前视图stud_view2的内容。*/
SELECT*FROMstud_view2
GO
ALTERVIEWstud_view2
AS
SELECTstud_id,name,gender,mark
FROMstudJnfo
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2023年粗糙度测试仪资金申请报告
- 2023年多谱勒天气雷达资金申请报告
- DB14T-玉米穗青贮饲料生产技术规程
- 工程目标管理承包责任书范文
- 法理考卷分章节习题
- 《 云服务提供商的合作博弈研究》
- 《基于心一肾一子宫轴理论指导下雷火灸结合子午流注开穴法治疗肾虚血瘀型慢性盆腔炎患者的个案报告》
- 2024义务教育信息科技新课标2022版考试真题库附含答案
- 2024小学语文新课程2022版标准测试题【含答案】
- 北师大版小学数学四年级上册线与角《角的度量(一)》示范教学课件
- 漫展商业计划书
- 外研版(2019)选择性必修 第一册Unit 2 Onwards and upwards Understanding ideas课件
- 高一数学试卷第一单元及高一数学试卷及答案(人教版)
- 三 《联系生活实际 弘扬工匠精神》(教学课件)-【中职专用】高二语文精讲课堂(高教版2023·职业模块)
- 大数据公开课 - Scala基础课件
- 产业链人才培养策略
- 介入鞘管脱出应急预案脚本
- 共振波简介介绍
- 新版九年级英语全册重点短语归纳
- 展馆展板施工方案
- 造口袋更换流程
评论
0/150
提交评论