SQL创建视图

if exists (select * from sysobjects where name = 'View_Jm_EdsProd')
 drop view View_Jm_EdsProd
 go
 --创建视图
create view View_Jm_EdsProd 
with encryption
as
   select * from Tab_EdsProd where Mid>1
go
--使用视图--
select *from  View_Jm_EdsProd 

主题格式
create view X
as
sql语句
go