USE [dbUsers]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF  EXISTS
    (SELECT *
        FROM SYSOBJECTS WHERE name = 'sp_addUsers')
    DROP PROCEDURE [sp_addUsers]
GO
CREATE PROCEDURE [sp_addUsers]
(
    @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
GO
/*
exec sp_addUsers 'user', '[email protected]', 'user', 'user', 'userm', 'ee11cbb19052e40b07aac0ca060c23ee
'
*/