runing22的博客

原创 sql server 事务处理例子

begin tran one_tran declare @sum_errors int;   //声明error总数，这个用来判断事务是否回滚 set @sum_errors = 0; update tbl_recruit_resume set entry_status = 0 where id = 26; set @sum_errors = @sum_errors + @@error;