search

guibranco / BancosBrasileiros

🇧🇷 :bank: :clipboard: Brazilian banks list
https://guibranco.github.io/BancosBrasileiros/
The Unlicense
433 stars 163 forks source link

Comando Sql para inserção perde os zeros na frente no campo BankId #42

Closed silverio27 closed 3 years ago

silverio27 commented 4 years ago

Sugestão: INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('001','BANCO DO BRASIL S/A', '00.000.000/0001-91', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('002','BANCO CENTRAL DO BRASIL', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('003','BANCO DA AMAZONIA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('004','BANCO DO NORDESTE DO BRASIL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('007','BANCO NAC DESENV. ECO. SOCIAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('008','BANCO MERIDIONAL DO BRASIL', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('020','BANCO DO ESTADO DE ALAGOAS S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('021','BANCO DO ESTADO DO ESPIRITO SANTO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('022','BANCO DE CREDITO REAL DE MINAS GERAIS SA', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('024','BANCO DO ESTADO DE PERNAMBUCO', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('025','BANCO ALFA S/A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('026','BANCO DO ESTADO DO ACRE S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('027','BANCO DO ESTADO DE SANTA CATARINA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('028','BANCO DO ESTADO DA BAHIA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('029','BANCO DO ESTADO DO RIO DE JANEIRO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('030','BANCO DO ESTADO DA PARAIBA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('031','BANCO DO ESTADO DE GOIAS S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('032','BANCO DO ESTADO DO MATO GROSSO S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('033','BANCO DO ESTADO DE SAO PAULO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('034','BANCO DO ESADO DO AMAZONAS S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('035','BANCO DO ESTADO DO CEARA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('036','BANCO DO ESTADO DO MARANHAO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('037','BANCO DO ESTADO DO PARA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('038','BANCO DO ESTADO DO PARANA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('039','BANCO DO ESTADO DO PIAUI S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('041','BANCO DO ESTADO DO RIO GRANDE DO SUL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('047','BANCO DO ESTADO DE SERGIPE S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('048','BANCO DO ESTADO DE MINAS GERAIS S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('059','BANCO DO ESTADO DE RONDONIA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('070','BANCO DE BRASILIA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('077','BANCO INTER S.A', '00.416.968/0001-01', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('085','COOPERATIVA CENTRAL DE CREDITO - AILOS', '05.463.212/0001-29', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('102','XP INVESTIMENTOS', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('104','CAIXA ECONOMICA FEDERAL', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('106','BANCO ITABANCO S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('107','BANCO BBM S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('109','BANCO CREDIBANCO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('116','BANCO B.N.L DO BRASIL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('125','BRASIL PLURAL S.A. BANCO MÚLTIPLO', '45.246.410/0001-55', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('148','MULTI BANCO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('151','CAIXA ECONOMICA DO ESTADO DE SAO PAULO', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('153','CAIXA ECONOMICA DO ESTADO DO R.G.SUL', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('165','BANCO NORCHEM S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('166','BANCO INTER-ATLANTICO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('168','BANCO C.C.F. BRASIL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('175','CONTINENTAL BANCO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('184','BBA - CREDITANSTALT S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('197','STONE PAGAMENTOS S.A.', '16.501.555/0002-38', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('199','BANCO FINANCIAL PORTUGUES', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('200','BANCO FRICRISA AXELRUD S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('201','BANCO AUGUSTA INDUSTRIA E COMERCIAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('204','BANCO S.R.L S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('205','BANCO SUL AMERICA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('206','BANCO MARTINELLI S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('208','BANCO PACTUAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('210','DEUTSCH SUDAMERIKANICHE BANK AG', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('211','BANCO SISTEMA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('212','BANCO MATONE S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('213','BANCO ARBI S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('214','BANCO DIBENS S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('215','BANCO AMERICA DO SUL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('216','BANCO REGIONAL MALCON S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('217','BANCO AGROINVEST S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('218','BS2', '71.027.866/0001-34', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('219','BANCO DE CREDITO DE SAO PAULO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('220','BANCO CREFISUL', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('221','BANCO GRAPHUS S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('222','BANCO AGF BRASIL S. A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('223','BANCO INTERUNION S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('224','BANCO FIBRA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('225','BANCO BRASCAN S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('228','BANCO ICATU S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('229','BANCO CRUZEIRO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('230','BANCO BANDEIRANTES S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('231','BANCO BOAVISTA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('232','BANCO INTERPART S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('233','BANCO MAPPIN S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('234','BANCO LAVRA S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('235','BANCO LIBERAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('236','BANCO CAMBIAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('237','BANCO BRADESCO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('239','BANCO BANCRED S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('240','BANCO DE CREDITO REAL DE MINAS GERAIS S.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('241','BANCO CLASSICO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('242','BANCO EUROINVEST S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('243','BANCO MÁXIMA S.A', '33.923.798/0001-00', '2020-03-20 17:00:00.000', 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('244','BANCO CIDADE S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('245','BANCO EMPRESARIAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('246','BANCO ABC ROMA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('247','BANCO OMEGA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('249','BANCO INVESTCRED S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('250','BANCO SCHAHIN CURY S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('251','BANCO SAO JORGE S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('252','BANCO FININVEST S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('254','BANCO PARANA BANCO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('255','MILBANCO S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('256','BANCO GULVINVEST S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('258','BANCO INDUSCRED S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('260','Nu Pagamentos S.A', '18.236.120/0001-58', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('261','BANCO VARIG S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('262','BANCO BOREAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('263','BANCO CACIQUE', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('264','BANCO PERFORMANCE S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('265','BANCO FATOR S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('266','BANCO CEDULA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('267','BANCO BBM-COM.C.IMOB.CFI S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('275','BANCO REAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('277','BANCO PLANIBANC S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('282','BANCO BRASILEIRO COMERCIAL', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('290','PagSeguro Internet S.A.', '08.561.701/0001-01', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('291','BANCO DE CREDITO NACIONAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('294','BCR - BANCO DE CREDITO REAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('295','BANCO CREDIPLAN S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('300','BANCO DE LA NACION ARGENTINA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('302','BANCO DO PROGRESSO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('303','BANCO HNF S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('304','BANCO PONTUAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('308','BANCO COMERCIAL BANCESA S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('318','BANCO B.M.G. S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('320','BANCO INDUSTRIAL E COMERCIAL', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('323','MercadoPago.com Representações Ltda.', '10.573.521/0001-91', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('332','Acesso Soluções de Pagamento S.A.', '13.140.088/0001-99', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('335','Órama DTVM S.A.', '13.293.225/0001-25', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('336','BANCO C6 S.A.', '31.872.495/0001-72', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('341','BANCO ITAU S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('346','BANCO FRANCES E BRASILEIRO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('347','BANCO SUDAMERIS BRASIL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('351','BANCO BOZANO SIMONSEN S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('353','BANCO GERAL DO COMERCIO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('356','ABN AMRO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('366','BANCO SOGERAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('369','PONTUAL', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('370','BEAL - BANCO EUROPEU PARA AMERICA LATINA', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('372','BANCO ITAMARATI S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('375','BANCO FENICIA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('376','CHASE MANHATTAN BANK S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('388','BANCO MERCANTIL DE DESCONTOS S/A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('389','BANCO MERCANTIL DO BRASIL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('392','BANCO MERCANTIL DE SAO PAULO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('394','BANCO B.M.C. S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('399','BANCO BAMERINDUS DO BRASIL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('409','UNIBANCO - UNIAO DOS BANCOS BRASILEIROS', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('412','BANCO NACIONAL DA BAHIA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('415','BANCO NACIONAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('420','BANCO NACIONAL DO NORTE S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('422','BANCO SAFRA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('424','BANCO NOROESTE S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('434','BANCO FORTALEZA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('453','BANCO RURAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('456','BANCO TOKIO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('464','BANCO SUMITOMO BRASILEIRO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('466','BANCO MITSUBISHI BRASILEIRO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('472','LLOYDS BANK PLC', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('473','BANCO FINANCIAL PORTUGUES S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('477','CITIBANK N.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('479','BANCO DE BOSTON S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('480','BANCO PORTUGUES DO ATLANTICO-BRASIL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('483','BANCO AGRIMISA S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('487','DEUTSCHE BANK S.A - BANCO ALEMAO', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('488','BANCO J. P. MORGAN S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('489','BANESTO BANCO URUGAUAY S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('492','INTERNATIONALE NEDERLANDEN BANK N.V.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('493','BANCO UNION S.A.C.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('494','BANCO LA REP. ORIENTAL DEL URUGUAY', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('495','BANCO LA PROVINCIA DE BUENOS AIRES', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('496','BANCO EXTERIOR DE ESPANA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('498','CENTRO HISPANO BANCO', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('499','BANCO IOCHPE S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('501','BANCO BRASILEIRO IRAQUIANO S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('502','BANCO SANTANDER S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('504','BANCO MULTIPLIC S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('505','BANCO GARANTIA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('600','BANCO LUSO BRASILEIRO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('601','BFC BANCO S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('602','BANCO PATENTE S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('604','BANCO INDUSTRIAL DO BRASIL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('607','BANCO SANTOS NEVES S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('608','BANCO OPEN S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('610','BANCO V.R. S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('611','BANCO PAULISTA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('612','BANCO GUANABARA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('613','BANCO PECUNIA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('616','BANCO INTERPACIFICO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('617','BANCO INVESTOR S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('618','BANCO TENDENCIA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('621','BANCO APLICAP S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('622','BANCO DRACMA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('623','BANCO PANAMERICANO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('624','BANCO GENERAL MOTORS S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('625','BANCO ARAUCARIA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('626','BANCO FICSA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('627','BANCO DESTAK S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('628','BANCO CRITERIUM S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('629','BANCORP BANCO COML. E. DE INVESTMENTO', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('630','BANCO INTERCAP S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('633','BANCO REDIMENTO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('634','BANCO TRIANGULO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('635','BANCO DO ESTADO DO AMAPA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('637','BANCO SOFISA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('638','BANCO PROSPER S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('639','BIG S.A. - BANCO IRMAOS GUIMARAES', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('640','BANCO DE CREDITO METROPOLITANO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('641','BANCO EXCEL ECONOMICO S/A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('643','BANCO SEGMENTO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('645','BANCO DO ESTADO DE RORAIMA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('647','BANCO MARKA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('648','BANCO ATLANTIS S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('649','BANCO DIMENSAO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('650','BANCO PEBB S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('652','BANCO FRANCES E BRASILEIRO SA', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('653','BANCO INDUSVAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('654','BANCO A. J. RENNER S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('655','BANCO VOTORANTIM S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('656','BANCO MATRIX S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('657','BANCO TECNICORP S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('658','BANCO PORTO REAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('702','BANCO SANTOS S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('705','BANCO INVESTCORP S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('707','BANCO DAYCOVAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('711','BANCO VETOR S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('713','BANCO CINDAM S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('715','BANCO VEGA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('718','BANCO OPERADOR S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('719','BANCO PRIMUS S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('720','BANCO MAXINVEST S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('721','BANCO CREDIBEL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('722','BANCO INTERIOR DE SAO PAULO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('724','BANCO PORTO SEGURO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('725','BANCO FINABANCO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('726','BANCO UNIVERSAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('728','BANCO FITAL S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('729','BANCO FONTE S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('730','BANCO COMERCIAL PARAGUAYO S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('731','BANCO GNPP S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('732','BANCO PREMIER S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('733','BANCO NACOES S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('734','BANCO GERDAU S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('735','BANCO NEON', '',NULL, 1); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('736','BANCO UNITED S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('737','THECA', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('738','MARADA', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('739','BGN', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('740','BCN BARCLAYS', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('741','BRP', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('742','EQUATORIAL', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('743','BANCO EMBLEMA S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('744','THE FIRST NATIONAL BANK OF BOSTON', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('745','CITIBAN N.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('746','MODAL S\A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('747','RABOBANK DO BRASIL', '01.023.570/0001-60', '2020-04-23 22:00:00.000', 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('748','SICREDI', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('749','BRMSANTIL SA', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('750','BANCO REPUBLIC NATIONAL OF NEW YORK (BRA', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('751','DRESDNER BANK LATEINAMERIKA-BRASIL S/A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('752','BANCO BANQUE NATIONALE DE PARIS BRASIL S', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('753','BANCO COMERCIAL URUGUAI S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('755','BANCO MERRILL LYNCH S.A', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('756','BANCO COOPERATIVO DO BRASIL S.A.', '', NULL, 0); INSERT INTO Banco (BankId, Name, Document, UpdatedAt, IsDeleted) VALUES ('757','BANCO KEB DO BRASIL S.A.', '', NULL, 0);

guibranco commented 4 years ago

O código do banco de 3 dígitos, chamado COMPE, tem tamanho fixo de 3 dígitos. Esse valor sendo menor que 3 deve ser preenchido automaticamente pelo sistema com os zeros a esquerda.

Um campo "char(3)" vai consumir 3 bytes de armazenamento. apenas para armazenar 1 ou 2 zeros em menos de 100 registros (1-99).

Um campo "smallint" ou "smallint(3)" vão consumir 2 bytes de armazenamento.

Caso precise exibir o 0 a esquerda, pode ser usar um atributo chamado de zerofill ou no momento do select usar uma função de pad e adicionar os zeros.

silverio27 commented 4 years ago

Certo!

guibranco commented 4 years ago

Versão 2.0 irá conter essa melhoria!

silverio27 commented 4 years ago

Show!