太悲剧了。。存储过程 写错了

[lijing3333]

CREATE PROCEDURE [dbo].[P_AddUserTask]
(
@award int,
@userId int,
@state int output
)
AS
declare @result int
	set @result=(select count(1) from PwdProtection where userId=@userId)
	if @result=1 
	then
		set @state=@result
	else
		@result=0
	end
	SET NOCOUNT ON;
GO

我这个应该怎么写哇？？ 求教 求教

[ForFumm]

楼主想干嘛？

[东那个升]

CREATE PROCEDURE [dbo].[P_AddUserTask]
(
@award int,
@userId int,
@state int output
)
AS
declare @result int
    set @result=(select count(1) from PwdProtection where userId=@userId)
    if @result=1 
    
        set @state=@result
    else
        set @result=0
GO

？

[dearbinge]

CREATE PROCEDURE [dbo].[P_AddUserTask]
(
@award int,
@userId int,
@state int output
)
AS
SET NOCOUNT ON
declare @result int
    select @result = count(1) from PwdProtection where userId=@userId
    if @result=1 
    then
        set @state=@result
    else
        @result=0
    end
SET NOCOUNT OFF
GO

[东那个升]

去掉 THEN else 后面加个SET 去掉END