CREATE PROCEDURE dbo.SP_BL_PAY_PWD_CHECK
@user_no varchar(20) ,
@user_pwd varchar(64) , -- 霸烙拌沥 菩胶况靛
@sp_rtn int OUTPUT -- 馆券蔼 府畔 (0:沥惑)
AS
BEGIN
SELECT @sp_rtn = -1
, @user_no = IsNull(@user_no , '')
, @user_pwd = IsNull(@user_pwd , '')
IF Len(@user_no) < 1 OR Len(@user_pwd) < 1
BEGIN
--涝仿蔼 坷幅.
SELECT @sp_rtn = -1
RETURN
END
IF EXISTS( SELECT 1
FROM account.dbo.user_profile WITH(NOLOCK)
WHERE user_no = @user_no
AND user_pwd = @user_pwd )
BEGIN
--厚剐锅龋 八荤 己傍.
SELECT @sp_rtn = 0
END
ELSE
BEGIN
--厚剐锅龋 八荤 角菩.
SELECT @sp_rtn = -2
END
RETURN
END
GO