创建视图
if exists (select * from sysobjects where name = 'view_t') -- view_t 视图名称
drop view [dbo].[view_t] --如果存在删除视图
go
create view view_t -- view_t 视图名称
as [查询sql]
go
创建视图
if exists (select * from sysobjects where name = 'view_t') -- view_t 视图名称
drop view [dbo].[view_t] --如果存在删除视图
go
create view view_t -- view_t 视图名称
as [查询sql]
go