1if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_prepRegister]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 2drop procedure [dbo].[p_prepRegister]
 3GO
 4
 5create procedure [dbo].[p_prepRegister]
 6@account varchar(20),
 7@pwd char(40),
 8@nickname nvarchar(16),
 9@question nvarchar(20),
10@answer char(40),
11@email varchar(100)
12as
13
14IF not exists (SELECT * FROM [user] WHERE account=@account)
15BEGIN
16    INSERT INTO [user](account,pwd,nickname,question,answer,friendset,email) values(@account,@pwd,@nickname,@question,@answer,1,@email)
17END
18GO
19
20if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_Register]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
21drop procedure [dbo].[p_Register]
22GO
23
24create procedure [dbo].[p_Register]
25@account varchar(20),
26@pwd char(40),
27@nickname nvarchar(16),
28@question nvarchar(20),
29@answer char(40),
30@email varchar(100)
31as
32
33IF not exists (SELECT * FROM [user] WHERE account=@account)
34BEGIN
35    exec p_prepRegister @account,@pwd,@nickname,@question,@answer,@email
36    if isNull(@@IDENTITY,0) > 0
37    BEGIN
38        DECLARE @id bigint
39        SET @id=@@IDENTITY
40        INSERT INTO [info](bloger,title,sub,photo) values(@id,@nickname+N'的BLOG', N'','/ui/img/bloger_head.jpg')
41        INSERT INTO [stat](bloger,topic,comment,leave,trackback,"view") values(@id,0,0,0,0,0)
42    END
43END
44GO