sql server 存储过程 查询语句查询 前七天，七天内

• 查询前七天：

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 @