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