SQL SERVER中的视图
时间:2022-03-10 17:17
create view v_student
as
select stuname,sex,age from T_student
create view v_teacher_salary
select dept,profession,max(salary) as maxsalary
from t_teacher
group by dept,profession
having max(salary)>3000
create view v_student
as
select r.stuname,r.sex,c.deptname from T_student r ,t_dept c where deptid='1109024102'
with check option
(因为在视图中已经定义了CHECK约束条件,所以如果要对视图进行其他操作的时候,其depid必须指定为11090241032)
只读视图
与上面类似,如果创建只读视图的话,只需要在结尾加上关键字WITH READ ONLY
SQL SERVER中的视图,布布扣,bubuko.com