TSql query rollback commit template

USE [dbname]

BEGIN TRAN

/*tabella users*/
alter table Users add IdAgency int;
IF (@@ERROR <> 0) GOTO ERR_HANDLER
/*tabella Registrations*/
alter table Registrations add IdAgency int;
IF (@@ERROR <> 0) GOTO ERR_HANDLER

/****** Object:  Table [dbo].[Agency]    Script Date: 02/10/2012 10:52:12 ******/
CREATE TABLE [dbo].[Agencies](
     [Id] [int] IDENTITY(1,1) NOT NULL,
     [Name] [nvarchar](50) NOT NULL,
     [ContactName] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Agency] PRIMARY KEY CLUSTERED
(
     [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
IF (@@ERROR <> 0) GOTO ERR_HANDLER

ALTER TABLE [dbo].[Users]  WITH CHECK ADD  CONSTRAINT [FK_Users_Agencies] FOREIGN KEY([IdAgency]) REFERENCES [dbo].[Agencies] ([Id]);
IF (@@ERROR <> 0) GOTO ERR_HANDLER
ALTER TABLE [dbo].[Users] CHECK CONSTRAINT [FK_Users_Agencies];
IF (@@ERROR <> 0) GOTO ERR_HANDLER
ALTER TABLE [dbo].[Registrations]  WITH CHECK ADD  CONSTRAINT [FK_Registrations_Agencies] FOREIGN KEY([IdAgency]) REFERENCES [dbo].[Agencies] ([Id]);
IF (@@ERROR <> 0) GOTO ERR_HANDLER
ALTER TABLE [dbo].[Registrations] CHECK CONSTRAINT [FK_Registrations_Agencies];
IF (@@ERROR <> 0) GOTO ERR_HANDLER
Commit tran



ERR_HANDLER:
PRINT 'Unexpected error occurred!'
ROLLBACK TRAN