From 1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1 Mon Sep 17 00:00:00 2001 From: Lucas Faria Mendes Date: Mon, 30 Mar 2026 10:38:18 -0300 Subject: chore: location --- Gestor.Application.Migration.Files.20200219_03.SQL | 468 --------------------- 1 file changed, 468 deletions(-) delete mode 100644 Gestor.Application.Migration.Files.20200219_03.SQL (limited to 'Gestor.Application.Migration.Files.20200219_03.SQL') diff --git a/Gestor.Application.Migration.Files.20200219_03.SQL b/Gestor.Application.Migration.Files.20200219_03.SQL deleted file mode 100644 index 17e1099..0000000 --- a/Gestor.Application.Migration.Files.20200219_03.SQL +++ /dev/null @@ -1,468 +0,0 @@ -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 1) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (1,1, N'BANCO DO BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 10) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (10,41, N'BANCO DO ESTADO DO RIO GRANDE DO SUL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 100) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (100,738, N'BANCO MORADA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 101) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (101,739, N'BANCO BGN S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 102) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (102,740, N'BANCO BARCLAYS S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 103) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (103,741, N'BANCO RIBEIRAO PRETO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 104) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (104,743, N'BANCO EMBLEMA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 105) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (105,745, N'BANCO CITIBANK S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 106) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (106,746, N'BANCO MODAL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 107) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (107,747, N'BANCO RABOBANK INTERNATIONAL BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 108) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (108,748, N'BANCO COOPERATIVO SICREDI S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 109) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (109,749, N'BANCO SIMPLES S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 11) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (11,44, N'BANCO BVA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 110) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (110,751, N'DRESDNER BANK BRASIL S.A. BANCO MULTIPLO'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 111) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (111,752, N'BANCO BNP PARIBAS BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 112) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (112,753, N'NBC BANK BRASIL S. A. - BANCO M?LTIPLO'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 113) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (113,756, N'BANCO COOPERATIVO DO BRASIL S.A. - BANCOOB'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 114) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (114,757, N'BANCO KEB DO BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 115) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (115,0, N'NENHUM'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 116) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (116,85, N'BANCO CECRED'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 117) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (117,290, N'PAGSEGURO INTERNET S.A'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 12) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (12,45, N'BANCO OPPORTUNITY S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 13) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (13,47, N'BANCO DO ESTADO DE SERGIPE S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 14) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (14,62, N'HIPERCARD BANCO M?LTIPLO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 15) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (15,63, N'BANCO IBI S.A. - BANCO M?LTIPLO'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 16) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (16,65, N'BANCO LEMON S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 17) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (17,66, N'BANCO MORGAN STANLEY S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 18) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (18,69, N'BPN BRASIL BANCO M?LTIPLO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 19) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (19,70, N'BRB - BANCO DE BRASILIA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 2) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (2,3, N'BANCO DA AMAZONIA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 20) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (20,72, N'BANCO RURAL MAIS S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 21) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (21,73, N'BB BANCO POPULAR DO BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 22) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (22,74, N'BANCO J. SAFRA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 23) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (23,75, N'BANCO CR2 S/A'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 24) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (24,76, N'BANCO KDB DO BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 25) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (25,77, N'BANCO INTERMEDIUM S/A'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 26) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (26,79, N'JBS BANCO S/A'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 27) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (27,81, N'CONC?RDIA BANCO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 28) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (28,96, N'BANCO BM&F DE SERVI?OS DE LIQUIDA??O E CUST?DIA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 29) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (29,104, N'CAIXA ECONOMICA FEDERAL'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 3) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (3,4, N'BANCO DO NORDESTE DO BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 30) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (30,107, N'BANCO BBM S/A'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 31) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (31,151, N'BANCO NOSSA CAIXA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 32) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (32,208, N'BANCO UBS PACTUAL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 33) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (33,212, N'BANCO MATONE S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 34) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (34,213, N'BANCO ARBI S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 35) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (35,214, N'BANCO DIBENS S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 36) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (36,217, N'BANCO JOHN DEERE S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 37) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (37,218, N'BANCO BONSUCESSO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 38) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (38,222, N'BANCO CALYON BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 39) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (39,224, N'BANCO FIBRA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 4) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (4,19, N'BANCO AZTECA DO BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 40) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (40,225, N'BANCO BRASCAN S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 41) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (41,229, N'BANCO CRUZEIRO DO SUL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 42) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (42,230, N'UNICARD BANCO M?LTIPLO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 43) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (43,233, N'BANCO GE CAPITAL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 44) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (44,237, N'BANCO BRADESCO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 45) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (45,241, N'BANCO CLASSICO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 46) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (46,243, N'BANCO M?XIMA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 47) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (47,246, N'BANCO ABC BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 48) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (48,248, N'BANCO BOAVISTA INTERATLANTICO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 49) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (49,249, N'BANCO INVESTCRED UNIBANCO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 5) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (5,21, N'BANESTES S.A. BANCO DO ESTADO DO ESPIRITO SANTO'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 50) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (50,250, N'BANCO SCHAHIN S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 51) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (51,254, N'PARAN? BANCO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 52) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (52,263, N'BANCO CACIQUE S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 53) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (53,265, N'BANCO FATOR S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 54) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (54,266, N'BANCO CEDULA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 55) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (55,300, N'BANCO DE LA NACION ARGENTINA'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 56) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (56,318, N'BANCO BMG S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 57) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (57,341, N'BANCO ITAU S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 58) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (58,356, N'BANCO ABN AMRO REAL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 59) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (59,366, N'BANCO SOCIETE GENERALE BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 6) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (6,25, N'BANCO ALFA S.A'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 60) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (60,370, N'BANCO WESTLB DO BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 61) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (61,376, N'BANCO J.P. MORGAN S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 62) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (62,389, N'BANCO MERCANTIL DO BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 63) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (63,394, N'BANCO FINASA BMC S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 64) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (64,399, N'HSBC BANK BRASIL S.A. - BANCO MULTIPLO'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 65) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (65,409, N'UNIBANCO-UNIAO DE BANCOS BRASILEIROS S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 66) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (66,412, N'BANCO CAPITAL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 67) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (67,422, N'BANCO SAFRA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 68) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (68,453, N'BANCO RURAL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 69) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (69,456, N'BANCO DE TOKYO-MITSUBISHI UFJ BRASIL S/A'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 7) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (7,33, N'BANCO SANTANDER BANESPA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 70) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (70,464, N'BANCO SUMITOMO MITSUI BRASILEIRO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 71) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (71,477, N'CITIBANK N.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 72) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (72,487, N'DEUTSCHE BANK S.A. - BANCO ALEMAO'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 73) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (73,488, N'JPMORGAN CHASE BANK, NATIONAL ASSOCIATION'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 74) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (74,492, N'ING BANK N.V.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 75) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (75,494, N'BANCO DE LA REPUBLICA ORIENTAL DEL URUGUAY'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 76) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (76,495, N'BANCO DE LA PROVINCIA DE BUENOS AIRES'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 77) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (77,505, N'BANCO CREDIT SUISSE (BRASIL) S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 78) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (78,600, N'BANCO LUSO BRASILEIRO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 79) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (79,604, N'BANCO INDUSTRIAL DO BRASIL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 8) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (8,37, N'BANCO DO ESTADO DO PAR? S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 80) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (80,610, N'BANCO VR S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 81) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (81,611, N'BANCO PAULISTA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 82) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (82,612, N'BANCO GUANABARA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 83) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (83,613, N'BANCO PECUNIA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 84) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (84,623, N'BANCO PANAMERICANO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 85) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (85,626, N'BANCO FICSA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 86) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (86,630, N'BANCO INTERCAP S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 87) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (87,633, N'BANCO RENDIMENTO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 88) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (88,634, N'BANCO TRIANGULO S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 89) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (89,637, N'BANCO SOFISA S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 9) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (9,40, N'BANCO CARGILL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 90) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (90,638, N'BANCO PROSPER S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 91) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (91,643, N'BANCO PINE S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 92) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (92,653, N'BANCO INDUSVAL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 93) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (93,654, N'BANCO A.J. RENNER S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 94) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (94,655, N'BANCO VOTORANTIM S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 95) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (95,707, N'BANCO DAYCOVAL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 96) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (96,719, N'BANIF - BANCO INTERNACIONAL DO FUNCHAL (BRASIL), S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 97) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (97,721, N'BANCO CREDIBEL S.A.'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 98) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (98,734, N'BANCO GERDAU S.A'); -END -IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 99) -BEGIN - INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (99,735, N'BANCO POTTENCIAL S.A.'); -END \ No newline at end of file -- cgit v1.2.3