参考彭泽江老师视频《sqlserver数据库学习》
纯手敲
视图=create view view_name as + sql语句
use zhangyanandb
GO
--新建视图查询所有教师表（接存储过程创建的库与表）
create view getteachers AS
select * from teacher
GO
--调用
select * from getteachers;
--更改视图
alter view getteachers AS
select name,subject from teacher
GO
--调用
select * from getteachers;
--删除
drop view getteachers
GO
--调用
select * from getteachers;
执行信息如下：
--调用
select * from getteachers
受影响的行: 0
时间: 0.021s
[SQL]
--更改视图
alter view getteachers AS
select name,subject from teacher
受影响的行: 0
时间: 0.021s
[SQL]
--调用
select * from getteachers
受影响的行: 0
时间: 0.021s
[SQL]
--删除
drop view getteachers
受影响的行: 0
时间: 0.021s
[SQL]
--调用
select * from getteachers
[Err] 42S02 - [SQL Server]对象名 'getteachers' 无效。
查询结果：
优点：封装复杂查询语句、减少网络传输
缺点：不能传参，可移植性低