求助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
少了个 ， 号
[解决办法]
参数间少逗号
