https://stackoverflow.com/questions/11531352/how-to-rollback-a-transaction-in-a-stored-procedure
BEGIN TRANSACTION; BEGIN TRY -- Some code COMMIT TRANSACTION; END TRY BEGIN CATCH ROLLBACK TRANSACTION; END CATCH;
原文：http://www.cnblogs.com/chucklu/p/7347524.html