"UserLogin" Stored Procedure

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.

        
    CREATE Procedure UserLogin
    (
        @Email    nvarchar(100),
        @Password nvarchar(20),
        @UserName nvarchar(100) OUTPUT
    )
    AS

    SELECT
        @UserName = Name

    FROM
        Users

    WHERE
        Email = @Email
    AND
        Password = @Password
        

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