use [xk-zcx]
go
select CouNo ,CouName ,Credit ,SchoolTime into new_course
from Course
where WillNum>20
go
select s.StuNo,StuName,c.CouNo,CouName into my_class
from Student s,Course c,StuCou sc,Class cl
where s.StuNo =sc.StuNo and c.CouNo =sc.CouNo and cl.ClassNo =s.ClassNo and ClassName ='01 旅游管理'
go
insert Department
values ('11','数学系')
insert Department(DepartName,DepartNo)
values ('物理系','12')
insert Department(DepartNo,DepartName)
values ('13','化学系')
go
select *
from Department
go
insert into Class
select '20110001','03 旅游管理','03'
union
select '20110002','03 旅游管理','03'
union
select '20110003','02 旅游管理','02'
union
select '20110004','02 旅游管理','02'
go
select *
from Class
go
delete from achievement
where CouNo =001