"UserLogin" 存储过程

描述:

This 存储过程 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.