CREATE Procedure UP_VerifyLogin
(
    @username      varchar(50),
    @password   varchar(50)
)
AS
SELECT 
    password = @password
FROM 
    tbl_users
WHERE 
    username = @username
  AND 
    password = @password
GO