begin tranbegin statementendif (@@error <> 0)begin rollback tran returnendcommit tran 转载于:https://www.cnblogs.com/vawe86/archive/2010/12/15/1906420.html