CREATE PROC sp_SystemSecurity_Query
(
@StartId INT = NULL,
@EndId INT = NULL,
@Attribute INT = NULL,
@Operator VARCHAR(50) = NULL,
@StartTime DATETIME = NULL,
@EndTime DATETIME = NULL,
@ProjectId INT = NULL
)
AS
SET NOCOUNT ONSELECT *
FROM systemsecurity
WHERE (@StartId IS NULL OR @StartId IS NOT NULL AND SecurityId >= @StartId)
AND (@EndId IS NULL OR @EndId IS NOT NULL AND SecurityId <= @EndId)
AND (@StartTime IS NULL OR @StartTime IS NOT NULL AND OccuredTime >= @StartTime)
AND (@EndTime IS NULL OR @EndTime IS NOT NULL AND OccuredTime <= @EndTime)
AND (@Operator IS NULL OR @Operator IS NOT NULL AND Operator = @Operator)
AND (@Attribute IS NULL OR @Attribute IS NOT NULL AND Attribute = @Attribute)SET NOCOUNT OFF
GO
(
@StartId INT = NULL,
@EndId INT = NULL,
@Attribute INT = NULL,
@Operator VARCHAR(50) = NULL,
@StartTime DATETIME = NULL,
@EndTime DATETIME = NULL,
@ProjectId INT = NULL
)
AS
SET NOCOUNT ONSELECT *
FROM systemsecurity
WHERE (@StartId IS NULL OR @StartId IS NOT NULL AND SecurityId >= @StartId)
AND (@EndId IS NULL OR @EndId IS NOT NULL AND SecurityId <= @EndId)
AND (@StartTime IS NULL OR @StartTime IS NOT NULL AND OccuredTime >= @StartTime)
AND (@EndTime IS NULL OR @EndTime IS NOT NULL AND OccuredTime <= @EndTime)
AND (@Operator IS NULL OR @Operator IS NOT NULL AND Operator = @Operator)
AND (@Attribute IS NULL OR @Attribute IS NOT NULL AND Attribute = @Attribute)SET NOCOUNT OFF
GO
exec sp_SystemSecurity_Query '1','','','sysop','2004-8-3','',''
我执行了这条语句,出来的结果总是空