CREATE procedure [dbo].[insert_SP]
AS
DECLARE @errorcode int
BEGIN TRAN t1
INSERT INTO TaBLE1 VALUES(2)
INSERT INTO TaBLE2 VALUES('A')
SELECT @errorcode = @@ERROR
PRINT @errorcode
IF(@errorcode<>0)
BEGIN
GOTO PROBLEM
END
INSERT INTO TaBLE3 VALUES(3)
COMMIT TRAN t1
PROBLEM: 
IF(@errorcode<>0)
BEGIN
PRINT 'Unexpected error occured'
ROLLBACK TRAN t1
END

GO

create table dbo.table1(aCol int);

create table dbo.table2(aCol int);

create table dbo.table3(aCol int);

go
CREATE procedure [dbo].[insert_SP]
AS
BEGIN
DECLARE @errorcode int
BEGIN TRAN t1
begin try
    INSERT INTO dbo.table1 VALUES(2)
    INSERT INTO dbo.table2 VALUES('A')
    INSERT INTO dbo.table3 VALUES(3)
    COMMIT TRAN t1
end try
begin catch
    PRINT 'Unexpected error occured'
    ROLLBACK TRAN t1
end catch
END

GO

exec dbo.insert_SP;
go

drop procedure dbo.insert_SP;
go

drop table dbo.table1;
drop table dbo.table2;
drop table dbo.table3;
go