fnPasswordUsed
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @UserID | int | IN | |
| @Password | nvarchar(255) | IN |
Definition
Copy
create FUNCTION [dbo].[fnPasswordUsed]
(
@UserID int,
@Password nvarchar(255)
)
RETURNS bit
AS
BEGIN
DECLARE @PasswordUsed bit
SET @PasswordUsed=0
IF EXISTS (
SELECT TOP 1 [ID]
FROM [dbo].[ClientUserPasswordHistory]
WHERE [UserID] = @UserID AND [Password]=@Password )
SET @PasswordUsed=1
RETURN @PasswordUsed
END