帮你查了一下,可以回滚,而且事务可以嵌套,各管各的
根据大牛说的最好再结合使用TransactionScope Class
http://stackoverflow.com/questions/31421770/using-transactionscope-around-a-stored-procedure-with-transaction-in-sql-server
https://msdn.microsoft.com/en-us/library/system.transactions.transactionscope(v=vs.110).aspx