我正在尝试使用默认参数创建一个存储过程,在我的查询中,我会这样做:
DECLARE @mydate DATETIME
DECLARE @MT DATETIME
DECLARE @MY DATETIME
SELECT @mydate = GETDATE()
SELECT @MT = DATEPART(MONTH,@mydate)
SELECT @MY = DATEPART(YEAR,@mydate)
SELECT * FROM ....在我的存储过程中,我尝试了如下方法,但是当我执行存储过程时,它会提示我输入参数值:
USE ..
GO
..
ALTER PROCEDURE ...
(@mydate DATETIME
,@MT DATETIME
,@MY DATETIME)
AS
BEGIN ...
SELECT @mydate = GETDATE()
SELECT @MT = DATEPART(MONTH,@mydate)
SELECT @MY = DATEPART(YEAR,@mydate)
---
SELECT * FROM ....如何像在查询中一样设置存储过程中的参数值?
发布于 2012-08-09 23:25:06
试试这个..。
我只放了一个参数,因为其他参数都依赖于它。
优先方法
USE ..
GO
..
ALTER PROCEDURE yourSP
(@mydateParam DATETIME)
AS
BEGIN ...
SELECT @mydate = @mydateParam
SELECT @MT = DATEPART(MONTH,@mydate)
SELECT @MY = DATEPART(YEAR,@mydate)
---
SELECT * FROM ....呼叫SP的步骤:
DECLARE @mydateParam DATETIME
SELECT @mydateParam = GETDATE()
execute yourSP @mydateParam第二种方法
ALTER Procedure yourSP
@mydateParam datetime = null
AS
BEGIN ...
IF @mydateParam is null
SET @mydateParam = getdate()
SELECT @mydate = @mydateParam
SELECT @MT = DATEPART(MONTH,@mydate)
SELECT @MY = DATEPART(YEAR,@mydate)
---
SELECT * FROM ....呼叫SP的步骤:
DECLARE @mydateParam DATETIME
SELECT @mydateParam = GETDATE()
execute yourSP @mydateParam或
execute yourSPhttps://stackoverflow.com/questions/11885960
复制相似问题