-------------------------------------------------
---功能描述:验证用户登陆
---0,用户不存在
---1,密码错误
---2,成功
------------------------------------------------
CREATE PROCEDURE UserLogin
@UserID nvarchar(50),
@UserPassword nvarchar(50)
as
declare @iReturn int
select * from WareUser where userid=@userid
if(@@rowcount<1)
begin-----------0
set @iReturn=0
end-------------0
else
begin------------1
select * from WareUser where userid=@userID and userpassword=@userpassword
if(@@rowcount<1)
begin-----------2
set @iReturn=1
end-------------2
else
begin-----------3
set @iReturn=2
end-------------3
end------------1
return @iReturn
GO