SQL Service 数据库 基本操作 视图 触发器 游标 存储过程

use NewTest1

---声明视图---
create view NewViewte
as
select StudentInfo.name as 姓名,StudentInfo.sex as 性别,course.name as 课程 from StudentInfo join Course on StudentInfo.Cid= Course.idselec