USP_CLIENTUSERS_NULLPASSWORD

Parameters

Parameter Parameter Type Mode Description
@CLIENTUSERSID int IN

Definition

Copy


create procedure dbo.USP_CLIENTUSERS_NULLPASSWORD
(
  @CLIENTUSERSID int
   )
as
begin

set nocount on;

update dbo.ClientUsers set [Password] = NULL where id = @CLIENTUSERSID

update dbo.ClientUserPasswordHistory set[Password] = NULL where UserId = @CLIENTUSERSID

end