web应用程序开发教程-第08章.pptVIP

创建视图 创建新视图 创建视图 创建视图向导 创建视图 创建视图向导 创建视图 CREATE VIEW语句创建视图。? CREATE VIEW 视图名 [ WITH 视图参数 ] AS SELECT语句 ?【例】使用CREATE VIEW命令创建视图EmpView。? CREATE VIEW dbo.EmpView AS SELECT dbo.EmpInfo.Emp_name, dbo.EmpInfo.Sex, dbo.EmpInfo.Wage, dbo.EmpInfo.Title, dbo.DepInfo.Dep_name FROM dbo.EmpInfo INNER JOIN dbo.DepInfo ON dbo.DepInfo.Dep_id = dbo.EmpInfo.Dep_id 创建视图 WITH子句支持的视图属性 【例】使用CREATE VIEW命令创建加密视图EmpView1： CREATE VIEW dbo.EmpView WITH ENCRYPTION AS SELECT dbo.EmpInfo.Emp_name, dbo.EmpInfo.Sex, dbo.EmpInfo.Wage, dbo.EmpInfo.Title, dbo.DepInfo.Dep_name FROM dbo.EmpInfo INNER JOIN dbo.D