求助Must declare the variable '@PushDay'
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: sd
-- Create date: 2012-02-03 15:40
-- Description: 重新启动任务
-- =============================================
ALTER PROCEDURE [dbo].[USP_OTSS_SendSgsExpiredRestartTask] 
@BusinessTaskId INT
@PushDay INT
AS
BEGIN

BEGIN TRANSACTION

UPDATE [OTSS_SendSgsTask]
SET [TaskStatus] = 0,[EndTime] = (select dateadd(day,@PushDay,(select getdate())))
WHERE [BusinessTaskId] = @BusinessTaskId

COMMIT TRANSACTION

END

Must declare the variable '@PushDay'哪错了？

------解决方案--------------------
ALTER PROCEDURE [dbo].[USP_OTSS_SendSgsExpiredRestartTask]
@BusinessTaskId INT,
@PushDay INT
AS
BEGIN

BEGIN TRANSACTION

UPDATE [OTSS_SendSgsTask]
SET [TaskStatus] = 0,[EndTime] = (select dateadd(day,@PushDay,(select getdate())))
WHERE [BusinessTaskId] = @BusinessTaskId

COMMIT TRANSACTION

END

少了个 ， 号
------解决方案--------------------
参数间少逗号