SP - insertuser

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  Hwang Jun - Beom
-- Create date: 2007/03/23
-- Description: insert user
-- =============================================
ALTER PROCEDURE [dbo].[insertuser_sp]
 -- Add the parameters for the stored procedure here
 @id  VARCHAR(15),
 @passwd  VARCHAR(20),
 @name  VARCHAR(10),
 @season  DECIMAL(3,0),
 @email  VARCHAR(50),
 @phone  VARCHAR(11),
 @university INT,
 @major  INT,
 @ipaddress VARCHAR(3),
 @result  int OUTPUT
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
 DECLARE @i_count int;
 SELECT @i_count = count(*) FROM userdb WHERE userid = @id;

 IF @i_count != 0
  BEGIN
   SET @result = 1;
   RETURN;
  END

 INSERT INTO userdb VALUES(@id, @passwd, @name, @season, @email, @phone, @university, @major, @ipaddress);

 DECLARE @i_useridx int;
 SELECT @i_useridx = idx FROM userdb WHERE userid = @id;
 INSERT INTO auth VALUES(0, @i_useridx);
 
 SET @result = 0;
 RETURN;
END