使用SQL语句创建一个视图V1,要求显示学号,姓名,课程名和成绩字段,并给...答:create view 视图名 as select '学号','姓名','课程名','成绩' from t go alter view 视图名 with encryption--对视图进行加密 as select '学号','姓名','课程名','成绩' from t go
用sql创建一个学生信息视图V_STU。(含Sno,Sname,Sage,Sdept)。_百度知 ...答:create view v_stu as select sno,sname,sage,sdept from student 第一题:create view v_stua as select sno,sname,sage,sdept from v_stu where sage>18;第二题:create view stu_a as select sno,sname,cname,grade from v_stu where classno="200608";第三题:create view c_stu as s...