2.视图创建和使用语法?
1.首先判断是否存在
if exists (select * from sysobjects where name = '视图名')
drop view View_EdsProd
Go
2. 创建视图
create view View_EdsProd as select * from Tab_EdsProd where Mid>1(条件) go
3. 使用视图
select *from View_EdsProd
1.首先判断是否存在
if exists (select * from sysobjects where name = '视图名')
drop view View_EdsProd
Go
2. 创建视图
create view View_EdsProd as select * from Tab_EdsProd where Mid>1(条件) go
3. 使用视图
select *from View_EdsProd