# "GetUserByUserName" Stored Procedure

Description:

This stored procedure retrieves a User's id and Role based on their UserName.

Definition:

    	CREATE  PROCEDURE TT_GetUserByUserName
    	(
    		@UserName nvarchar(50)
    	)

    	AS

    	SELECT
    		UserID,
    		UserName,
    		Password,
    		RoleID

    	FROM
    		TT_Users WHERE UserName = @UserName

Database Tables Used:

The primary key in the Users table is the UserID identity field.