围绕多个插入或更新使用事务的正确方法

What is the proper way to test for insert/update failures and rollback this transaction if there are any? I don't think what I have will work since my inserts/updates are 3 separate statements and the @@ROWCOUNT will only reflect the last statement executed.What is the proper way to test for insert/updat