sql server 存储过程查询语句查询前七天，七天内_sqlserver指定日期往前推7天-优快云博客

本文链接：https://blog.youkuaiyun.com/yanghrwork/article/details/91793897

本文介绍如何在SQL Server中使用存储过程查询最近七天内的数据，包括查询前七天以及包含前后七天的范围。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

查询前七天：

USE [CablewayMonitorPlatform]
GO
/****** Object:  StoredProcedure [dbo].[SelectPortableHistoryResult]    Script Date: 06/12/2019 21:24:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[SelectPortableHistoryResult]
	
	@OId varchar(20),
	@Time varchar(50)
AS
BEGIN
	
	SET NOCOUNT ON;
	declare @sqlcommand nvarchar(MAX)=N''
	
	set @sqlcommand='select * from t_PortableResult where 1=1 '
	
   if(@OId is not null)
  
    set @sqlcommand=@sqlcommand+' and OId=' +cast(@OId as varchar)
   
    if(@Time is not null)
    begin
    set @sqlcommand=@sqlcommand+' and Time<= '''+@Time+'''' + ' and DATEADD(dd,7,Time)> '''+ @Time+''''
    end
    print(@sqlcommand)
    exec(@sqlcommand)
    		
END

查询七天内（前后七天）：

USE [CablewayMonitorPlatform]
GO
/****** Object:  StoredProcedure [dbo].[SelectPortableHistoryResult]    Script Date: 06/12/2019 21:46:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[SelectPortableHistoryResult]
	
	@OId varchar(20),
	@Time varchar(50)
AS
BEGIN
	
	SET NOCOUNT ON;
	declare @sqlcommand nvarchar(MAX)=N''
	
	set @sqlcommand='select * from t_PortableResult where 1=1 '
	
   if(@OId is not null)
  
    set @sqlcommand=@sqlcommand+' and OId=' +cast(@OId as varchar)
   
    if(@Time is not null)
    begin
    set @sqlcommand=@sqlcommand+' and DateDiff(dd,Time,cast('''+@Time+''' as varchar))<=7 '
    end
    print(@sqlcommand)
    exec(@sqlcommand)
    		
END