事务的操作

set xact_abort on
begin transaction --开始事务
update card set banlance=banlance-800 where id=1
update card set banlance=banlance+800 where id=2
commit transaction --提交事务