INSERT HUB.dbo.uf_codigos(column_list) SELECT column_list FROM
EQUIBRAS.dbo.uf_codigos <where...>
?

You can do:

INSERT INTO HUB.dbo.uf_codigos (<column_list>)
SELECT <column_list> FROM EQUIBRAS.dbo.uf_codigos
WHERE ....

In the above replace <column_list> with your columns, and you may need to
replace 'dbo' with correct schema name if the tables are in different
schema. The WHERE is not necessary if you will be inserting all rows.

HTH,

Plamen Ratchev
http://www.SQLStudio.com