create procedure pr_test (
    @Name    varchar(8),
    @Age    tinyint,
    @class    varchar(8)
)
as 
begin
    begin tran 
    begin try
        update A set Name = @Name where ...
        update B set Age = @Age where ...
        update C set class = @class where ...
        commit tran
    end try
    begin catch
        rollback tran
    end catch
    
end