USP_INCREASE_CLIENTUSERS_FAILEDATTEMPTS
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientUsersID | int | IN |
Definition
Copy
create procedure dbo.USP_INCREASE_CLIENTUSERS_FAILEDATTEMPTS
(@ClientUsersID int)
as
begin
update dbo.CLIENTUSERS set NUMFAILEDATTEMPTS = isnull(NUMFAILEDATTEMPTS,0)+1 where ID = @ClientUsersID;
select NUMFAILEDATTEMPTS from dbo.CLIENTUSERS where ID = @ClientUsersID;
end