SQLServer考试题目(2)

语法:alter table table_name add constraint constraint_name

default value for column */

--增加default约束

alter table Teacher add constraint DF_Teacher_Title default '助教' for Title --删除default约束

alter table Teacher drop constraint DF_Teacher_Title

--查询?王平?老师教过的所有学生姓名、成绩

select s.StuName,sc.CourseNo,sc.TeaNo,sc.Score from Student s join SelectCourse sc on s.StuNo=sc.StuNo where sc.TeaNo =( select TeaNo from Teacher )

--列出所有选修了”操作系统”课程的学生的学号、姓名 select s.StuNo,s.StuName,sc.CourseNo from Student s join SelectCourse sc on s.StuNo=sc.StuNo where sc.CourseNo =( select CourseNo from Course )

where CourseName='操作系统' where TeaName='王平'