27,579
社区成员
发帖
与我相关
我的任务
分享
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[vwTbllog]') and OBJECTPROPERTY(id, N'IsView') = 1)
begin
create view vwTbllog as
(select id,datecreated,errorcode as code,level,category,source,message,exception,stacktrace,userid from tbllog)
end
go
CREATE VIEW vwTbllog
AS
SELECT id
,datecreated
,errorcode AS code
,level
,category
,source
,message
,exception
,stacktrace
,userid
FROM tbllog
IF OBJECT_ID('vwTbllog', N'V') IS NOT NULL
EXEC(N'CREATE VIEW vwTbllog AS
SELECT id,datecreated,errorcode AS code,level,category,source,message,exception,stacktrace,userid FROM tbllog')
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[vwTbllog]') and OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW vwTbllog
GO
create view vwTbllog as
(select id,datecreated,errorcode as code,level,category,source,message,exception,stacktrace,userid from tbllog)
go