How do i login with Email and select records with UserName

Question

here is code for login, but am not sure if i got it right, also how do i fetch record using username after login with email

 

ALTER PROCEDURE [dbo].[Validate_User]
 @Id int,
     @UserName NVARCHAR(200),
       @Email NVARCHAR(200),
      @Password NVARCHAR(20)


AS
BEGIN
      SET NOCOUNT ON;
      DECLARE @UserId INT, @LastLoginDate DATETIME

      SELECT @UserId = UserId, @LastLoginDate = LastLogin
      FROM User3 WHERE UserName = @Email AND [Password] = @PassWord

      IF @UserId IS NOT NULL
      BEGIN
            IF NOT EXISTS(SELECT UserId FROM UserActivation WHERE UserId = @UserId)
            BEGIN
                  UPDATE User3
                  SET LastLogin = GETDATE()
                  WHERE UserId = @UserId
                  SELECT @UserId [UserId] -- User Valid
            END
            ELSE
            BEGIN
                  SELECT -2 -- User not activated.
            END
      END
      ELSE
      BEGIN
            SELECT -1 -- User invalid.
      END
END