SQL语句SQL Server 续续

1.选择数据库

use hermosadb;

 

2.创建视图

create view v_student

as 

select sno,sname,ssex

from student;

 

3.在视图上创建视图

create view v_student_girl (sno,sname,ssex)

as 

select sno,sname,ssex

from v_student

where ssex=2

with check option;

 

4.删除视图

drop view v_grade_avg;

 

5.创建视图，当有聚集函数时，视图名后要写出列名

create view v_grade_avg (sno,avg)

as 

select sno,avg(scgrade)

from grade

group by sno

having avg(scgrade)>=60;

 

6.更新视图

update v_student_girl

set sname='huihui'

where sname='hui';

 

7.在视图中插入数据

insert into v_student_girl values(11,'xian');