Guest User

Untitled

a guest
Aug 20th, 2012
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. USE [dbUsers]
  2. SET ANSI_NULLS ON
  3. GO
  4. SET QUOTED_IDENTIFIER ON
  5. GO
  6. IF  EXISTS
  7.     (SELECT *
  8.         FROM SYSOBJECTS WHERE name = 'sp_addUsers')
  9.     DROP PROCEDURE [sp_addUsers]
  10. GO
  11. CREATE PROCEDURE [sp_addUsers]
  12. (
  13.     @username   varchar(10),
  14.     @email      varchar(50),
  15.     @lname      varchar(25),
  16.     @fname      varchar(25),
  17.     @mname      varchar(25),
  18.     @password   varchar(50)
  19. )
  20. AS
  21. BEGIN
  22. DECLARE
  23.  
  24. @return varchar(30)
  25.  
  26. IF  EXISTS(SELECT   * FROM
  27.             tbl_users
  28.         WHERE   u_username = @username
  29.         OR  u_email = @email)
  30.     BEGIN
  31.         SET @return = 'USER ALREADY EXIST'
  32.     END
  33. ELSE
  34.     BEGIN
  35.         INSERT  INTO tbl_users
  36.         (u_lname, u_fname, u_mname, u_username, u_password, u_email)
  37.         VALUES
  38.         (@lname, @fname, @mname, @username, @password, @email)
  39.         SET @return = '1 USER ADDED TO THE SYSTEM'
  40.     END
  41. SELECT [RETURN] = @return
  42. END
  43. GO
  44. /*
  45. exec sp_addUsers 'user', '[email protected]', 'user', 'user', 'userm', 'ee11cbb19052e40b07aac0ca060c23ee
  46. '
  47. */
Advertisement
Add Comment
Please, Sign In to add comment