CREATE PROCEDURE [dbo].[sp_addsysUser]
(
    @username   varchar(10),
    @email      varchar(50),
    @lname      varchar(25),
    @fname      varchar(25),
    @mname      varchar(25),
    @password   varchar(50)
)
AS
BEGIN
DECLARE
    @return varchar(30)

        IF  EXISTS(SELECT   * FROM tbl_users
                WHERE   u_username  = @username
                OR      u_email     = @email)
        BEGIN
        SET @return = 'USER ALREADY EXIST'
        END
        ELSE
        BEGIN
        INSERT  INTO tbl_users
        (u_lname, u_fname, u_mname, u_username, u_password, u_email)
        VALUES
        (@lname, @fname, @mname, @username, @password, @email)
        SET @return = '1 USER ADDED TO THE SYSTEM'
        END
        SELECT [RETURN] = @return
END