begin transaction
declare @sumError int=0
update bank set balance=balance-1000 where cid='3'
set @sumError=@sumError+@@ERROR
update bank set balance=balance+1000 where cid=1
SET @sumError=@sumError+@@ERROR
if(@sumError<>0)
begin
rollback transaction
end
else
begin
commit transaction
end