从网上看到一个存储过程,其中可以判断是否存在该用户,存在则返回1,否则返回0
ALTER PROCEDURE dbo.IsValidUser
(
@userName varchar(50),
@password varchar(50) OUTPUT
)
AS
if Exists(Select Id From [User] Where [Name] = @userName)
Begin
Select @password = Password From [User] Where [name]= @userName
Select 1 -- Ture
End
Select 0 -- false我想问一下select 是否跟return是一个意思,这样不需要加
else
select 0就可以实现正确的逻辑了?
后面还有个select 0 ,所以总返回select 0
(
@userName varchar(50),
@password varchar(50) OUTPUT
)
AS
if Exists(Select Id From [User] Where [Name] = @userName)
Begin
Select @password = Password From [User] Where [name]= @userName
Select 1 -- Ture
End
else
Begin
Select 0 -- false
end这样就可以返回想要的结果了吧