USE [PassportBOIOLD]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[adduser]
@name varchar(64),
@passwd varchar(32),
@prompt varchar(32),
@answer varchar(32),
@truename varchar(32),
@idnumber varchar(32),
@email varchar(64),
@mobilenumber varchar(32),
@province varchar(32),
@city varchar(32),
@phonenumber varchar(32),
@address varchar(64),
@postalcode varchar(8),
@gender integer,
@birthday varchar(32),
@qq varchar(32),
@passwd2 varchar(32)
AS
BEGIN
BEGIN TRAN
DECLARE @id integer
DECLARE @now datetime
SELECT @now = getdate()
INSERT INTO account SELECT ISNULL(max(id), 16) + 16, @name, CONVERT(BINARY,@passwd,2), @now, 0 FROM account
SELECT @id = id FROM account WHERE name = @name
INSERT INTO users VALUES (@id, @prompt, @answer, @truename, @idnumber, @email, @mobilenumber, @province, @city, @phonenumber, @address, @postalcode, @gender, @birthday, @qq, CONVERT(BINARY,@passwd2,2))
EXEC [dbo].[adduserpoint] @id, 9, 10
COMMIT TRAN
END