fnUserIDByEmailAndPassword
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientsID | int | IN | |
| nchar | IN | ||
| @password | nvarchar(255) | IN |
Definition
Copy
CREATE FUNCTION [dbo].[fnUserIDByEmailAndPassword]
(
@ClientsID int,
@email nchar(100),
@password nvarchar(255)
)
RETURNS int
AS
BEGIN
declare @UserID int
SELECT top 1 @UserID = ID FROM ClientUsers WHERE ClientsID=@ClientsID AND Email=@email AND [Password]=@password
if @@ROWCOUNT = 0
SELECT @UserID = 0
RETURN @UserID
END