服务器: 消息 3903，级别 16，状态 1，过程 CreateRegisterUser，行 116

if Exists(select name from sysobjects where name='CreateRegisterUser' and type='P')
DROP PROC CreateRegisterUser
GOCREATE PROCEDURE CreateRegisterUser
-- FOR SubAgentUser
@UserID UNIQUEIDENTIFIER,
@BranchID UNIQUEIDENTIFIER,
@UserName NVARCHAR(200),
@UserPassword VARCHAR(200),
@LoginNum INT,
@LastLoginIP NVARCHAR(200),
@LastLoginTime DATETIME,
@ISPermission BIT,

-- FOR RegisterUser
@FirstName VARCHAR(200),
@LastName VARCHAR(200),
@AgencyName VARCHAR(200),
@AgencyManager VARCHAR(200),
@AgencyStreet VARCHAR(200),
@AcctCode VARCHAR(200),
@AgencyGDS VARCHAR(200),
@PsoudoCity VARCHAR(200),
@Country VARCHAR(200),
@State VARCHAR(200),
@City VARCHAR(200),
@ZipCode VARCHAR(200),
@Phone VARCHAR(200),
@Fax VARCHAR(200),
@EmailAddress VARCHAR(200),
@RegisterDate DATETIME,
@Question text,
@Answer text,
@Birthday DATETIME,
@Gender BIT,
@Street1 text,
@Street2 textASBEGIN TRANSACTIONINSERT INTO SubAgentUser(
UserID,
BranchID,
UserName,
UserPassword,
LoginNum,
LastLoginIP,
LastLoginTime,
ISPermission )VALUES(
@UserID,
@BranchID,
@UserName,
@UserPassword,
@LoginNum,
@LastLoginIP,
@LastLoginTime,
@ISPermission)IF @@ERROR<>0 GOTO ERR_HANDLEINSERT INTO RegisterUser(
UserID,
FirstName,
LastName,
AgencyName,
AgencyManager,
AgencyStreet,
AcctCode,
AgencyGDS,
PsoudoCity,
Country,
State,
City,
ZipCode,
Phone,
Fax,
EmailAddress,
RegisterDate,
Question,
Answer,
Birthday,
Gender,
Street1,
Street2
) VALUES(
@UserID,
@FirstName,
@LastName,
@AgencyName,
@AgencyManager,
@AgencyStreet,
@AcctCode,
@AgencyGDS,
@PsoudoCity,
@Country,
@State,
@City,
@ZipCode,
@Phone,
@Fax,
@EmailAddress,
@RegisterDate,
@Question,
@Answer,
@Birthday,
@Gender,
@Street1,
@Street2)IF @@ERROR<>0 GOTO ERR_HANDLECOMMIT TRANSACTIONERR_HANDLE:ROLLBACK TRANSACTION
（所影响的行数为 1 行）
（所影响的行数为 1 行）服务器: 消息 3903，级别 16，状态 1，过程 CreateRegisterUser，行 116
ROLLBACK TRANSACTION 请求没有对应的 BEGIN TRANSACTION。