# "UserLogin" Stored Procedure

Description:

This stored procedure authenticates a user against the Users table credential store. If the email/password combination is found, the user's UserName is returned.

Definition:

        CREATE Procedure TT_UserLogin
        (
            @UserName  nvarchar(100),
            @Password nvarchar(50)
        )
        AS

        SELECT
            UserName

        FROM
            TT_Users

        WHERE
            UserName = @UserName
        AND
            Password = @Password

Database Tables Used:

Users: The Users table contains the user crendential information used for forms-based authentication.