这个存储过程什么意思? 如题:对存储过程比较熟的大侠帮我看看这个存储过程: CREATE PROCEDURE [dbo].[pro_add_sms] @entid as varchar(20), @operatorid as int , @cmcontent as varchar(1000) , 。 。 @rvalue as varchar(50) output, @leftba as int output as
declare @rowcount as int , @usertypeid as int , @entslimit as int , @usersmsbalance as int , @entssmsbalance as int , @error as int begin select @usertypeid=usertypeid , @usersmsbalance=balance from qmsg_admin where operatorid=@operatorid set @error=@@error if @error<>0 begin set @rvalue='500' goto end1 end begin tran if @usertypeid=0 begin if @usersmsbalance >=@chargeCount begin update qmsg_admin set balance = balance - @chargeCount where operatorid=@operatorid set @rowcount=@@rowcount if @rowcount=0 begin set @rvalue = '100' rollback tran goto end1 end else begin set @leftba=@usersmsbalance-@chargeCount end
end end commit tran set @rvalue='0' end end1: 这是存储过程中的一些代码,省略了一部分