Sql query Template with error handling

BEGIN TRAN
BEGIN TRY
    /* PUT USEFUL STUFF HERE */

    /* WHEN YOU FEEL SAFE, CHANGE THIS TO COMMIT TRAN */
    ROLLBACK TRAN
END TRY
BEGIN CATCH
    ROLLBACK TRAN
    PRINT 'AT LINE: ' + CAST(ERROR_LINE() AS varchar(10));
    PRINT ERROR_MESSAGE();
END CATCH