USP_MATCH_CIPHER_BY_USERID
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | int | IN | |
| @CIPHER | nvarchar(max) | IN |
Definition
Copy
create procedure dbo.USP_MATCH_CIPHER_BY_USERID (@ID as int, @CIPHER as nvarchar(max))
as
begin
declare @ISVALID as int = 0
if exists (select 1 from dbo.CLIENTUSERSCIPHER where CLIENTUSERSID = @ID and CIPHER = @CIPHER)
begin
set @ISVALID = 1;
end
select @ISVALID as IsValid
end