希望在存储过程中设置默认值,但遇到错误,CONVERT似乎不存在。CONVERT可以在主体中工作,但不能在存储过程的参数部分中工作。如何将参数@StartDate设置为过去24个月的默认值?
CREATE PROCEDURE [dbo].[MyStoredProc]
@Id INT = NULL,
@startDate DATETIME = CONVERT(DATE, DATEADD(MONTH, -1 * 24, GETDATE())), -- last 24 months
@endDate DATETIME = CONVERT(DATE, GETDATE())
AS
BEGIN
SELECT @startDate;
END
GO发布于 2019-11-21 04:03:42
这是可行的!
CREATE procedure [dbo].[MyStoredProc]
@Id int = null
,@startDate datetime = null
,@endDate datetime = null
as
begin
SET @startDate = ISNULL(@startDate, CONVERT(DATE, DATEADD(MONTH, -1*24, GETDATE())));
select @startDate;
END
GOhttps://stackoverflow.com/questions/58961134
复制相似问题