存储过程

Create proc ups_cunchuguocheng

@from char(4),

@from char(4),

@balance money, --转账金额

@isok bit output –转账是否成功

As

Begin

--判断金额是否足够转账

Delcare @money money

Select @money =balance from bank where cid =@from

If @money-@balanece>=10

--开始转账

Begin transaction

Declare @sum int=o

--账户1扣钱

Update bank setbalance=balance-@balance where cid =@from

Set @sun =@sun+@@error

--账户2价钱

Updata bank set balance =balance+@balance where cid =@to

Set @sum=@sim+@@error

end

--判断执行是否成功

If @sum <>0

Begin

Set @resultNumber=2  --转账失败

Rollback

Else

Begin set @resultNumber=1 –转账成功

Commit

Else

Begin

Set @resultNumber=3—余额不足

end

End

 

 

执行Text

Declare @r int

Exec usp_transfer_bank @from=’0001’,@to=’0002’,@balance=900,@resultNumber=@r output

Print @r