fnUserIDByUsername

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@ClientsID	int	IN
@UserName	nvarchar(100)	IN

Definition

Copy



CREATE FUNCTION dbo.fnUserIDByUsername
(
    @ClientsID int,
    @UserName nvarchar(100)
)
RETURNS int
AS
    BEGIN
        declare @UserID int

        SELECT @UserID = ID FROM ClientUsers WHERE ClientsID=@ClientsID AND UserName=@UserName

        if @@ROWCOUNT = 0 
            SELECT @UserID = 0

        RETURN @UserID
    END