
Untitled
By: a guest on
Aug 20th, 2012 | syntax:
T-SQL | size: 0.90 KB | hits: 26 | expires: Never
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', 'hatred123x@yahoo.com', 'user', 'user', 'userm', 'ee11cbb19052e40b07aac0ca060c23ee
'
*/