修改密碼的預存程序

create PROCEDURE [dbo].[UP_Sys_User_Update_PassWord]
    @UserID       varchar(40),
    @OldPwd         varchar(80),
    @NewPwd       varchar(80)
AS
BEGIN
begin try
    declare @_oldPwd varchar(80)
    set @_oldPwd =(Select UPassWord from [Sys_User]
     where UserID = @UserID)

    if(@OldPwd = @_oldPwd)
  
        begin
            UPDATE [Sys_User] SET
    UPassWord = @NewPwd
    WHERE UserID=@UserID
      
     return 1
        end
    else
        begin
      return 0
        end
end try

begin catch
  return -1
end catch
END

 

調用預存程序
exec [UP_Sys_User_Update_PassWord] 'zym','4a6f2cddba69b82ccddd9364c4a6c119','bd78478509b17e91118ac1e8e5a8ffbe'