如何在查询中使用 GETDATE

Question

我正在查询数据，其中包含在 EXEC 命令末尾的查询末尾插入的日期，但如果可能的话，我想使用 GETDATE 函数来查询昨天，因为我计划按计划而不是手动运行这些查询。我不想每天都去编辑日期。

USE [EXP]
GO

DECLARE @DateFrom datetime;
SET @DateFrom = DATEADD(day, -1, cast(getdate() as date));

/****** Object:  Table [dbo].[Trans]    Script Date: 6/11/2021 9:25:00 AM ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Trans]') AND type in (N'U'))
DROP TABLE [dbo].[Trans]
GO

/****** Object:  Table [dbo].[Trans]    Script Date: 6/11/2021 9:25:00 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Trans](
    [Account] [varchar](8) NULL,
    [Amount] [money] NOT NULL,
    [typename] [varchar](20) NULL,
    [DateEffective] [datetime] NULL,
    [TranDesc] [varchar](200) NULL,
    [DRAmount] [money] NULL,
    [CRAmount] [money] NULL,
    [CUUser] [varchar](50) NULL,
    [Deleted] [bit] NULL
) ON [PRIMARY]
GO


--set identity_insert Trans on
insert into Trans
    ([Account]
    ,[Amount]
    ,[typename]
    ,[DateEffective]
    ,[TranDesc]
    ,[DRAmount]
    ,[CRAmount]
    ,[CUUser]
    ,[Deleted])
EXEC [FER_DP].[DP].[dbo].[Excel_Trans] @DateFrom;