cs_EventLog_GetEntry
ALTER PROCEDURE [dbo].cs_EventLog_GetEntry
(
@EntryID int
)
AS
SELECT EL.EventLogID,
EL.Message,
EL.Category,
EL.SettingsID,
EL.EventID,
EL.EventType,
EL.EventDate,
EL.MachineName
FROM cs_EventLog EL
WHERE EL.EventLogID = @EntryID
/**//*返回指定的事件信息*/
GO
ALTER PROCEDURE [dbo].cs_EventLog_GetEntry
(
@EntryID int
)
AS
SELECT EL.EventLogID,
EL.Message,
EL.Category,
EL.SettingsID,
EL.EventID,
EL.EventType,
EL.EventDate,
EL.MachineName
FROM cs_EventLog EL
WHERE EL.EventLogID = @EntryID
/**//*返回指定的事件信息*/
GO
cs_EventLog_GetEntries
ALTER PROCEDURE [dbo].cs_EventLog_GetEntries
(
@SettingsID int = -1
)
AS
SELECT TOP 1000
EL.EventLogID,
EL.Message,
EL.Category,
EL.SettingsID,
EL.EventID,
EL.EventType,
EL.EventDate,
EL.MachineName
FROM cs_EventLog EL
WHERE EL.SettingsID = @SettingsID
OR EL.SettingsID = -1
ORDER BY EL.EventLogID DESC
/**//*获取前1000条事件记录*/
GO
ALTER PROCEDURE [dbo].cs_EventLog_GetEntries
(
@SettingsID int = -1
)
AS
SELECT TOP 1000
EL.EventLogID,
EL.Message,
EL.Category,
EL.SettingsID,
EL.EventID,
EL.EventType,
EL.EventDate,
EL.MachineName
FROM cs_EventLog EL
WHERE EL.SettingsID = @SettingsID
OR EL.SettingsID = -1
ORDER BY EL.EventLogID DESC
/**//*获取前1000条事件记录*/
GO
cs_EventLog_Clear
ALTER PROCEDURE [dbo].cs_EventLog_Clear
(
@Date datetime
) AS
Delete FROM cs_EventLog where EventDate <= @Date
/**//*删除事件日志*/
SET QUOTED_IDENTIFIER OFF
/**//*当 QUOTED_IDENTIFIER 为 OFF 时,对于双引号和单引号的使用,SQL Server 遵循如下规则:
引号不能用于分隔标识符,而是用括号作为分隔符。
单引号或双引号可用于包含字符串。
如果使用双引号,嵌入的单引号不需要用两个单引号来表示:
*/
GO
ALTER PROCEDURE [dbo].cs_EventLog_Clear
(
@Date datetime
) AS
Delete FROM cs_EventLog where EventDate <= @Date
/**//*删除事件日志*/
SET QUOTED_IDENTIFIER OFF
/**//*当 QUOTED_IDENTIFIER 为 OFF 时,对于双引号和单引号的使用,SQL Server 遵循如下规则:
引号不能用于分隔标识符,而是用括号作为分隔符。
单引号或双引号可用于包含字符串。
如果使用双引号,嵌入的单引号不需要用两个单引号来表示:
*/
GO
cs_EventLog_Add
ALTER PROCEDURE [dbo].cs_EventLog_Add
(
@EventType int,
@Message ntext,
@Category nvarchar(256),
@MachineName nvarchar(256) = null,
@EventID int,
@SettingsID int
) AS
INSERT INTO [cs_EventLog]([Message], [Category], [SettingsID], [EventID], [EventType], [MachineName])
VALUES( @Message, @Category, @SettingsID, @EventID, @EventType, @MachineName)
/**//*添加事件日志*/
SET QUOTED_IDENTIFIER OFF
/**//*当 QUOTED_IDENTIFIER 为 OFF 时,对于双引号和单引号的使用,SQL Server 遵循如下规则:
引号不能用于分隔标识符,而是用括号作为分隔符。
单引号或双引号可用于包含字符串。
如果使用双引号,嵌入的单引号不需要用两个单引号来表示:
*/
GO
ALTER PROCEDURE [dbo].cs_EventLog_Add
(
@EventType int,
@Message ntext,
@Category nvarchar(256),
@MachineName nvarchar(256) = null,
@EventID int,
@SettingsID int
) AS
INSERT INTO [cs_EventLog]([Message], [Category], [SettingsID], [EventID], [EventType], [MachineName])
VALUES( @Message, @Category, @SettingsID, @EventID, @EventType, @MachineName)
/**//*添加事件日志*/
SET QUOTED_IDENTIFIER OFF
/**//*当 QUOTED_IDENTIFIER 为 OFF 时,对于双引号和单引号的使用,SQL Server 遵循如下规则:
引号不能用于分隔标识符,而是用括号作为分隔符。
单引号或双引号可用于包含字符串。
如果使用双引号,嵌入的单引号不需要用两个单引号来表示:
*/
GO