同时添加网站和论坛会员的存储过程

USE [sq8jyxq]
GO
/****** 对象:  StoredProcedure [sq8jyxq].[Pro_AddUsers]    脚本日期: 09/17/2009 17:18:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [sq8jyxq].[Pro_AddUsers]
 -- Add the parameters for the stored procedure here
@membername varchar(50),@pwd varchar(50),@email varchar(50),@tel varchar(50),
@yingyezhizhao varchar(50),@memberturename varchar(50),@companyadress varchar(50),
@callnumber varchar(50),@question1 varchar(50),@ask1 varchar(50),@question2 varchar(50),
@ask2 varchar(50),@tuiguang varchar(50),@sortid int,@groupid int,@regip char(15),@uid int,@result int output

AS
begin transaction
declare @errorSum int
set @errorSum=0  
insert into Tbmember(membername,pwd,email,tel,yingyezhizhao,memberturename,companyadress,callnumber,question1,ask1,question2,ask2,tuiguang,sortid,agree,regtime)
values(@membername,@pwd,@email,@tel,@yingyezhizhao,@memberturename,@companyadress,@callnumber,@question1,@ask1,@question2,@ask2,@tuiguang,@sortid,1,getdate())
set @errorSum=@errorSum+@@error
 if exists(select *  from  dnt_users where username=@membername)
   begin 
     set @errorSum=1
   end
 else
   begin
     insert into dnt_users(username,password,email,groupid) values(@membername,@pwd,@email,@groupid);select @uid=@@identity
     set @errorSum=@errorSum+@@error
   end
insert into dnt_userfields(uid) values(@uid)
set @errorSum=@errorSum+@@error
if @errorSum<>0
  begin
    set @result=-1
    rollback transaction
  end
else
  begin
    set @result=1
    commit transaction
  end