SET NOCOUNT ON DECLARE@RetrunValuenvarchar(1000) DECLARE@ERRORSUMINT SET@ERRORSUM=0 SET@RetrunValue='代理注册失败' BEGINTRANSACTION--事务开始 UPDATE tb_Gdf_Reg_Center SET BounsMoneyOut=BounsMoneyOut+@Agent_XinYuWHERE Member_Code=@p17 SET@ERRORSUM=@ERRORSUM+@@error IF@ERRORSUM=0 BEGIN SET@RetrunValue='代理注册成功' COMMITTRANSACTION END ELSE BEGIN SET@RetrunValue='代理注册失败' ROLLBACKTRANSACTION END