请问这个存储过程错在哪里？

[zcm1227cn]

create proc CheckLogin
(
@userName varchar(10),
@userPwd varchar(10),
@result varchar(50) output
)
as
begin
declare @number int
set @number=(select count(*) from login where userName=@userName and userPwd=@userPwd)
if(@number <> 0)
@result='success'
else
@result='fail'
end

服务器: 消息 170，级别 15，状态 1，过程 CheckLogin，行 12
第 12 行: '@result' 附近有语法错误。

[xeqtr1982]

create proc CheckLogin
(
@userName varchar(10),
@userPwd varchar(10),
@result varchar(50) output
)
as
begin
declare @number int
set @number=(select count(*) from login where userName=@userName and userPwd=@userPwd)
if(@number <> 0)
set @result='success'
else
set @result='fail'
end

[zcm1227cn]

疏忽了，谢谢

[frankwong]

对变量或者参数的赋值要用set,如:
set @result='abc'

[liangpei2008]

楼上正解：）
create proc CheckLogin
(
@userName varchar(10),
@userPwd varchar(10),
@result varchar(50) output
)
as
begin

if exists(select 1 from login where userName=@userName and userPwd=@userPwd)
select @result='success'
else
select @result='fail'
end

[YrLijon]

用SELECT 赋值好些

[keyanshang]

正解