sábado, 21 de abril de 2012

Tabla País para SQL Server

Esta es la tabla de país para una base de datos de SQL Server


/****** Script para crear la tabla con todos los paises ******/


CREATE TABLE [DIC_Pais](
      [PK_ID] [int] NOT NULL,
      [ISONUM] [int] NOT NULL CONSTRAINT [DF__DIC_Pais__ISONUM__38EE7070] DEFAULT (''),
[ISO2] [nvarchar](2) COLLATE Latin1_General_CI_AI NOT NULL CONSTRAINT [DF__DIC_Pais__ISO2__39E294A9]  DEFAULT (''),
[ISO3] [nvarchar](3) COLLATE Latin1_General_CI_AI NOT NULL CONSTRAINT [DF__DIC_Pais__ISO3__3AD6B8E2]  DEFAULT (''),
[NOMBRE] [nvarchar](80) COLLATE Latin1_General_CI_AI NOT NULL CONSTRAINT [DF__DIC_Pais__NOMBRE__3BCADD1B]  DEFAULT (''), CONSTRAINT [PK_DIC_Pais]
PRIMARY KEY CLUSTERED
(
 [PK_ID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]


/****** Despues de crear la table ejecutamos las siguientes instrucciones ******/
INSERT INTO DIC_Pais VALUES (1, 4, 'AF', 'AFG', 'Afganistán');
INSERT INTO DIC_Pais VALUES (2, 248, 'AX', 'ALA', 'Islas Gland');
INSERT INTO DIC_Pais VALUES (3, 8, 'AL', 'ALB', 'Albania');
INSERT INTO DIC_Pais VALUES (4, 276, 'DE', 'DEU', 'Alemania');
INSERT INTO DIC_Pais VALUES (5, 20, 'AD', 'AND', 'Andorra');
INSERT INTO DIC_Pais VALUES (6, 24, 'AO', 'AGO', 'Angola');
INSERT INTO DIC_Pais VALUES (7, 660, 'AI', 'AIA', 'Anguilla');
INSERT INTO DIC_Pais VALUES (8, 10, 'AQ', 'ATA', 'Antártida');
INSERT INTO DIC_Pais VALUES (9, 28, 'AG', 'ATG', 'Antigua y Barbuda');
INSERT INTO DIC_Pais VALUES (10, 530, 'AN', 'ANT', 'Antillas Holandesas');
INSERT INTO DIC_Pais VALUES (11, 682, 'SA', 'SAU', 'Arabia Saudí');
INSERT INTO DIC_Pais VALUES (12, 12, 'DZ', 'DZA', 'Argelia');
INSERT INTO DIC_Pais VALUES (13, 32, 'AR', 'ARG', 'Argentina');
INSERT INTO DIC_Pais VALUES (14, 51, 'AM', 'ARM', 'Armenia');
INSERT INTO DIC_Pais VALUES (15, 533, 'AW', 'ABW', 'Aruba');
INSERT INTO DIC_Pais VALUES (16, 36, 'AU', 'AUS', 'Australia');
INSERT INTO DIC_Pais VALUES (17, 40, 'AT', 'AUT', 'Austria');
INSERT INTO DIC_Pais VALUES (18, 31, 'AZ', 'AZE', 'Azerbaiyán');
INSERT INTO DIC_Pais VALUES (19, 44, 'BS', 'BHS', 'Bahamas');
INSERT INTO DIC_Pais VALUES (20, 48, 'BH', 'BHR', 'Bahréin');
INSERT INTO DIC_Pais VALUES (21, 50, 'BD', 'BGD', 'Bangladesh');
INSERT INTO DIC_Pais VALUES (22, 52, 'BB', 'BRB', 'Barbados');
INSERT INTO DIC_Pais VALUES (23, 112, 'BY', 'BLR', 'Bielorrusia');
INSERT INTO DIC_Pais VALUES (24, 56, 'BE', 'BEL', 'Bélgica');
INSERT INTO DIC_Pais VALUES (25, 84, 'BZ', 'BLZ', 'Belice');
INSERT INTO DIC_Pais VALUES (26, 204, 'BJ', 'BEN', 'Benin');
INSERT INTO DIC_Pais VALUES (27, 60, 'BM', 'BMU', 'Bermudas');
INSERT INTO DIC_Pais VALUES (28, 64, 'BT', 'BTN', 'Bhután');
INSERT INTO DIC_Pais VALUES (29, 68, 'BO', 'BOL', 'Bolivia');
INSERT INTO DIC_Pais VALUES (30, 70, 'BA', 'BIH', 'Bosnia y Herzegovina');
INSERT INTO DIC_Pais VALUES (31, 72, 'BW', 'BWA', 'Botsuana');
INSERT INTO DIC_Pais VALUES (32, 74, 'BV', 'BVT', 'Isla Bouvet');
INSERT INTO DIC_Pais VALUES (33, 76, 'BR', 'BRA', 'Brasil');
INSERT INTO DIC_Pais VALUES (34, 96, 'BN', 'BRN', 'Brunéi');
INSERT INTO DIC_Pais VALUES (35, 100, 'BG', 'BGR', 'Bulgaria');
INSERT INTO DIC_Pais VALUES (36, 854, 'BF', 'BFA', 'Burkina Faso');
INSERT INTO DIC_Pais VALUES (37, 108, 'BI', 'BDI', 'Burundi');
INSERT INTO DIC_Pais VALUES (38, 132, 'CV', 'CPV', 'Cabo Verde');
INSERT INTO DIC_Pais VALUES (39, 136, 'KY', 'CYM', 'Islas Caimán');
INSERT INTO DIC_Pais VALUES (40, 116, 'KH', 'KHM', 'Camboya');
INSERT INTO DIC_Pais VALUES (41, 120, 'CM', 'CMR', 'Camerún');
INSERT INTO DIC_Pais VALUES (42, 124, 'CA', 'CAN', 'Canadá');
INSERT INTO DIC_Pais VALUES (43, 140, 'CF', 'CAF', 'República Centroafricana');
INSERT INTO DIC_Pais VALUES (44, 148, 'TD', 'TCD', 'Chad');
INSERT INTO DIC_Pais VALUES (45, 203, 'CZ', 'CZE', 'República Checa');
INSERT INTO DIC_Pais VALUES (46, 152, 'CL', 'CHL', 'Chile');
INSERT INTO DIC_Pais VALUES (47, 156, 'CN', 'CHN', 'China');
INSERT INTO DIC_Pais VALUES (48, 196, 'CY', 'CYP', 'Chipre');
INSERT INTO DIC_Pais VALUES (49, 162, 'CX', 'CXR', 'Isla de Navidad');
INSERT INTO DIC_Pais VALUES (50, 336, 'VA', 'VAT', 'Ciudad del Vaticano');
INSERT INTO DIC_Pais VALUES (51, 166, 'CC', 'CCK', 'Islas Cocos');
INSERT INTO DIC_Pais VALUES (52, 170, 'CO', 'COL', 'Colombia');
INSERT INTO DIC_Pais VALUES (53, 174, 'KM', 'COM', 'Comoras');
INSERT INTO DIC_Pais VALUES (54, 180, 'CD', 'COD', 'República Democrática del Congo');
INSERT INTO DIC_Pais VALUES (55, 178, 'CG', 'COG', 'Congo');
INSERT INTO DIC_Pais VALUES (56, 184, 'CK', 'COK', 'Islas Cook');
INSERT INTO DIC_Pais VALUES (57, 408, 'KP', 'PRK', 'Corea del Norte');
INSERT INTO DIC_Pais VALUES (58, 410, 'KR', 'KOR', 'Corea del Sur');
INSERT INTO DIC_Pais VALUES (59, 384, 'CI', 'CIV', 'Costa de Marfil');
INSERT INTO DIC_Pais VALUES (60, 188, 'CR', 'CRI', 'Costa Rica');
INSERT INTO DIC_Pais VALUES (61, 191, 'HR', 'HRV', 'Croacia');
INSERT INTO DIC_Pais VALUES (62, 192, 'CU', 'CUB', 'Cuba');
INSERT INTO DIC_Pais VALUES (63, 208, 'DK', 'DNK', 'Dinamarca');
INSERT INTO DIC_Pais VALUES (64, 212, 'DM', 'DMA', 'Dominica');
INSERT INTO DIC_Pais VALUES (65, 214, 'DO', 'DOM', 'República Dominicana');
INSERT INTO DIC_Pais VALUES (66, 218, 'EC', 'ECU', 'Ecuador');
INSERT INTO DIC_Pais VALUES (67, 818, 'EG', 'EGY', 'Egipto');
INSERT INTO DIC_Pais VALUES (68, 222, 'SV', 'SLV', 'El Salvador');
INSERT INTO DIC_Pais VALUES (69, 784, 'AE', 'ARE', 'Emiratos Árabes Unidos');
INSERT INTO DIC_Pais VALUES (70, 232, 'ER', 'ERI', 'Eritrea');
INSERT INTO DIC_Pais VALUES (71, 703, 'SK', 'SVK', 'Eslovaquia');
INSERT INTO DIC_Pais VALUES (72, 705, 'SI', 'SVN', 'Eslovenia');
INSERT INTO DIC_Pais VALUES (73, 724, 'ES', 'ESP', 'España');
INSERT INTO DIC_Pais VALUES (74, 581, 'UM', 'UMI', 'Islas ultramarinas de Estados Unidos');
INSERT INTO DIC_Pais VALUES (75, 840, 'US', 'USA', 'Estados Unidos');
INSERT INTO DIC_Pais VALUES (76, 233, 'EE', 'EST', 'Estonia');
INSERT INTO DIC_Pais VALUES (77, 231, 'ET', 'ETH', 'Etiopía');
INSERT INTO DIC_Pais VALUES (78, 234, 'FO', 'FRO', 'Islas Feroe');
INSERT INTO DIC_Pais VALUES (79, 608, 'PH', 'PHL', 'Filipinas');
INSERT INTO DIC_Pais VALUES (80, 246, 'FI', 'FIN', 'Finlandia');
INSERT INTO DIC_Pais VALUES (81, 242, 'FJ', 'FJI', 'Fiyi');
INSERT INTO DIC_Pais VALUES (82, 250, 'FR', 'FRA', 'Francia');
INSERT INTO DIC_Pais VALUES (83, 266, 'GA', 'GAB', 'Gabón');
INSERT INTO DIC_Pais VALUES (84, 270, 'GM', 'GMB', 'Gambia');
INSERT INTO DIC_Pais VALUES (85, 268, 'GE', 'GEO', 'Georgia');
INSERT INTO DIC_Pais VALUES (86, 239, 'GS', 'SGS', 'Islas Georgias del Sur y Sandwich del Sur');
INSERT INTO DIC_Pais VALUES (87, 288, 'GH', 'GHA', 'Ghana');
INSERT INTO DIC_Pais VALUES (88, 292, 'GI', 'GIB', 'Gibraltar');
INSERT INTO DIC_Pais VALUES (89, 308, 'GD', 'GRD', 'Granada');
INSERT INTO DIC_Pais VALUES (90, 300, 'GR', 'GRC', 'Grecia');
INSERT INTO DIC_Pais VALUES (91, 304, 'GL', 'GRL', 'Groenlandia');
INSERT INTO DIC_Pais VALUES (92, 312, 'GP', 'GLP', 'Guadalupe');
INSERT INTO DIC_Pais VALUES (93, 316, 'GU', 'GUM', 'Guam');
INSERT INTO DIC_Pais VALUES (94, 320, 'GT', 'GTM', 'Guatemala');
INSERT INTO DIC_Pais VALUES (95, 254, 'GF', 'GUF', 'Guayana Francesa');
INSERT INTO DIC_Pais VALUES (96, 324, 'GN', 'GIN', 'Guinea');
INSERT INTO DIC_Pais VALUES (97, 226, 'GQ', 'GNQ', 'Guinea Ecuatorial');
INSERT INTO DIC_Pais VALUES (98, 624, 'GW', 'GNB', 'Guinea-Bissau');
INSERT INTO DIC_Pais VALUES (99, 328, 'GY', 'GUY', 'Guyana');
INSERT INTO DIC_Pais VALUES (100, 332, 'HT', 'HTI', 'Haití');
INSERT INTO DIC_Pais VALUES (101, 334, 'HM', 'HMD', 'Islas Heard y McDonald');
INSERT INTO DIC_Pais VALUES (102, 340, 'HN', 'HND', 'Honduras');
INSERT INTO DIC_Pais VALUES (103, 344, 'HK', 'HKG', 'Hong Kong');
INSERT INTO DIC_Pais VALUES (104, 348, 'HU', 'HUN', 'Hungría');
INSERT INTO DIC_Pais VALUES (105, 356, 'IN', 'IND', 'India');
INSERT INTO DIC_Pais VALUES (106, 360, 'ID', 'IDN', 'Indonesia');
INSERT INTO DIC_Pais VALUES (107, 364, 'IR', 'IRN', 'Irán');
INSERT INTO DIC_Pais VALUES (108, 368, 'IQ', 'IRQ', 'Iraq');
INSERT INTO DIC_Pais VALUES (109, 372, 'IE', 'IRL', 'Irlanda');
INSERT INTO DIC_Pais VALUES (110, 352, 'IS', 'ISL', 'Islandia');
INSERT INTO DIC_Pais VALUES (111, 376, 'IL', 'ISR', 'Israel');
INSERT INTO DIC_Pais VALUES (112, 380, 'IT', 'ITA', 'Italia');
INSERT INTO DIC_Pais VALUES (113, 388, 'JM', 'JAM', 'Jamaica');
INSERT INTO DIC_Pais VALUES (114, 392, 'JP', 'JPN', 'Japón');
INSERT INTO DIC_Pais VALUES (115, 400, 'JO', 'JOR', 'Jordania');
INSERT INTO DIC_Pais VALUES (116, 398, 'KZ', 'KAZ', 'Kazajstán');
INSERT INTO DIC_Pais VALUES (117, 404, 'KE', 'KEN', 'Kenia');
INSERT INTO DIC_Pais VALUES (118, 417, 'KG', 'KGZ', 'Kirguistán');
INSERT INTO DIC_Pais VALUES (119, 296, 'KI', 'KIR', 'Kiribati');
INSERT INTO DIC_Pais VALUES (120, 414, 'KW', 'KWT', 'Kuwait');
INSERT INTO DIC_Pais VALUES (121, 418, 'LA', 'LAO', 'Laos');
INSERT INTO DIC_Pais VALUES (122, 426, 'LS', 'LSO', 'Lesotho');
INSERT INTO DIC_Pais VALUES (123, 428, 'LV', 'LVA', 'Letonia');
INSERT INTO DIC_Pais VALUES (124, 422, 'LB', 'LBN', 'Líbano');
INSERT INTO DIC_Pais VALUES (125, 430, 'LR', 'LBR', 'Liberia');
INSERT INTO DIC_Pais VALUES (126, 434, 'LY', 'LBY', 'Libia');
INSERT INTO DIC_Pais VALUES (127, 438, 'LI', 'LIE', 'Liechtenstein');
INSERT INTO DIC_Pais VALUES (128, 440, 'LT', 'LTU', 'Lituania');
INSERT INTO DIC_Pais VALUES (129, 442, 'LU', 'LUX', 'Luxemburgo');
INSERT INTO DIC_Pais VALUES (130, 446, 'MO', 'MAC', 'Macao');
INSERT INTO DIC_Pais VALUES (131, 807, 'MK', 'MKD', 'ARY Macedonia');
INSERT INTO DIC_Pais VALUES (132, 450, 'MG', 'MDG', 'Madagascar');
INSERT INTO DIC_Pais VALUES (133, 458, 'MY', 'MYS', 'Malasia');
INSERT INTO DIC_Pais VALUES (134, 454, 'MW', 'MWI', 'Malawi');
INSERT INTO DIC_Pais VALUES (135, 462, 'MV', 'MDV', 'Maldivas');
INSERT INTO DIC_Pais VALUES (136, 466, 'ML', 'MLI', 'Malí');
INSERT INTO DIC_Pais VALUES (137, 470, 'MT', 'MLT', 'Malta');
INSERT INTO DIC_Pais VALUES (138, 238, 'FK', 'FLK', 'Islas Malvinas');
INSERT INTO DIC_Pais VALUES (139, 580, 'MP', 'MNP', 'Islas Marianas del Norte');
INSERT INTO DIC_Pais VALUES (140, 504, 'MA', 'MAR', 'Marruecos');
INSERT INTO DIC_Pais VALUES (141, 584, 'MH', 'MHL', 'Islas Marshall');
INSERT INTO DIC_Pais VALUES (142, 474, 'MQ', 'MTQ', 'Martinica');
INSERT INTO DIC_Pais VALUES (143, 480, 'MU', 'MUS', 'Mauricio');
INSERT INTO DIC_Pais VALUES (144, 478, 'MR', 'MRT', 'Mauritania');
INSERT INTO DIC_Pais VALUES (145, 175, 'YT', 'MYT', 'Mayotte');
INSERT INTO DIC_Pais VALUES (146, 484, 'MX', 'MEX', 'México');
INSERT INTO DIC_Pais VALUES (147, 583, 'FM', 'FSM', 'Micronesia');
INSERT INTO DIC_Pais VALUES (148, 498, 'MD', 'MDA', 'Moldavia');
INSERT INTO DIC_Pais VALUES (149, 492, 'MC', 'MCO', 'Mónaco');
INSERT INTO DIC_Pais VALUES (150, 496, 'MN', 'MNG', 'Mongolia');
INSERT INTO DIC_Pais VALUES (151, 500, 'MS', 'MSR', 'Montserrat');
INSERT INTO DIC_Pais VALUES (152, 508, 'MZ', 'MOZ', 'Mozambique');
INSERT INTO DIC_Pais VALUES (153, 104, 'MM', 'MMR', 'Myanmar');
INSERT INTO DIC_Pais VALUES (154, 516, 'NA', 'NAM', 'Namibia');
INSERT INTO DIC_Pais VALUES (155, 520, 'NR', 'NRU', 'Nauru');
INSERT INTO DIC_Pais VALUES (156, 524, 'NP', 'NPL', 'Nepal');
INSERT INTO DIC_Pais VALUES (157, 558, 'NI', 'NIC', 'Nicaragua');
INSERT INTO DIC_Pais VALUES (158, 562, 'NE', 'NER', 'Níger');
INSERT INTO DIC_Pais VALUES (159, 566, 'NG', 'NGA', 'Nigeria');
INSERT INTO DIC_Pais VALUES (160, 570, 'NU', 'NIU', 'Niue');
INSERT INTO DIC_Pais VALUES (161, 574, 'NF', 'NFK', 'Isla Norfolk');
INSERT INTO DIC_Pais VALUES (162, 578, 'NO', 'NOR', 'Noruega');
INSERT INTO DIC_Pais VALUES (163, 540, 'NC', 'NCL', 'Nueva Caledonia');
INSERT INTO DIC_Pais VALUES (164, 554, 'NZ', 'NZL', 'Nueva Zelanda');
INSERT INTO DIC_Pais VALUES (165, 512, 'OM', 'OMN', 'Omán');
INSERT INTO DIC_Pais VALUES (166, 528, 'NL', 'NLD', 'Países Bajos');
INSERT INTO DIC_Pais VALUES (167, 586, 'PK', 'PAK', 'Pakistán');
INSERT INTO DIC_Pais VALUES (168, 585, 'PW', 'PLW', 'Palau');
INSERT INTO DIC_Pais VALUES (169, 275, 'PS', 'PSE', 'Palestina');
INSERT INTO DIC_Pais VALUES (170, 591, 'PA', 'PAN', 'Panamá');
INSERT INTO DIC_Pais VALUES (171, 598, 'PG', 'PNG', 'Papúa Nueva Guinea');
INSERT INTO DIC_Pais VALUES (172, 600, 'PY', 'PRY', 'Paraguay');
INSERT INTO DIC_Pais VALUES (173, 604, 'PE', 'PER', 'Perú');
INSERT INTO DIC_Pais VALUES (174, 612, 'PN', 'PCN', 'Islas Pitcairn');
INSERT INTO DIC_Pais VALUES (175, 258, 'PF', 'PYF', 'Polinesia Francesa');
INSERT INTO DIC_Pais VALUES (176, 616, 'PL', 'POL', 'Polonia');
INSERT INTO DIC_Pais VALUES (177, 620, 'PT', 'PRT', 'Portugal');
INSERT INTO DIC_Pais VALUES (178, 630, 'PR', 'PRI', 'Puerto Rico');
INSERT INTO DIC_Pais VALUES (179, 634, 'QA', 'QAT', 'Qatar');
INSERT INTO DIC_Pais VALUES (180, 826, 'GB', 'GBR', 'Reino Unido');
INSERT INTO DIC_Pais VALUES (181, 638, 'RE', 'REU', 'Reunión');
INSERT INTO DIC_Pais VALUES (182, 646, 'RW', 'RWA', 'Ruanda');
INSERT INTO DIC_Pais VALUES (183, 642, 'RO', 'ROU', 'Rumania');
INSERT INTO DIC_Pais VALUES (184, 643, 'RU', 'RUS', 'Rusia');
INSERT INTO DIC_Pais VALUES (185, 732, 'EH', 'ESH', 'Sahara Occidental');
INSERT INTO DIC_Pais VALUES (186, 90, 'SB', 'SLB', 'Islas Salomón');
INSERT INTO DIC_Pais VALUES (187, 882, 'WS', 'WSM', 'Samoa');
INSERT INTO DIC_Pais VALUES (188, 16, 'AS', 'ASM', 'Samoa Americana');
INSERT INTO DIC_Pais VALUES (189, 659, 'KN', 'KNA', 'San Cristóbal y Nevis');
INSERT INTO DIC_Pais VALUES (190, 674, 'SM', 'SMR', 'San Marino');
INSERT INTO DIC_Pais VALUES (191, 666, 'PM', 'SPM', 'San Pedro y Miquelón');
INSERT INTO DIC_Pais VALUES (192, 670, 'VC', 'VCT', 'San Vicente y las Granadinas');
INSERT INTO DIC_Pais VALUES (193, 654, 'SH', 'SHN', 'Santa Helena');
INSERT INTO DIC_Pais VALUES (194, 662, 'LC', 'LCA', 'Santa Lucía');
INSERT INTO DIC_Pais VALUES (195, 678, 'ST', 'STP', 'Santo Tomé y Príncipe');
INSERT INTO DIC_Pais VALUES (196, 686, 'SN', 'SEN', 'Senegal');
INSERT INTO DIC_Pais VALUES (197, 891, 'CS', 'SCG', 'Serbia y Montenegro');
INSERT INTO DIC_Pais VALUES (198, 690, 'SC', 'SYC', 'Seychelles');
INSERT INTO DIC_Pais VALUES (199, 694, 'SL', 'SLE', 'Sierra Leona');
INSERT INTO DIC_Pais VALUES (200, 702, 'SG', 'SGP', 'Singapur');
INSERT INTO DIC_Pais VALUES (201, 760, 'SY', 'SYR', 'Siria');
INSERT INTO DIC_Pais VALUES (202, 706, 'SO', 'SOM', 'Somalia');
INSERT INTO DIC_Pais VALUES (203, 144, 'LK', 'LKA', 'Sri Lanka');
INSERT INTO DIC_Pais VALUES (204, 748, 'SZ', 'SWZ', 'Suazilandia');
INSERT INTO DIC_Pais VALUES (205, 710, 'ZA', 'ZAF', 'Sudáfrica');
INSERT INTO DIC_Pais VALUES (206, 736, 'SD', 'SDN', 'Sudán');
INSERT INTO DIC_Pais VALUES (207, 752, 'SE', 'SWE', 'Suecia');
INSERT INTO DIC_Pais VALUES (208, 756, 'CH', 'CHE', 'Suiza');
INSERT INTO DIC_Pais VALUES (209, 740, 'SR', 'SUR', 'Surinam');
INSERT INTO DIC_Pais VALUES (210, 744, 'SJ', 'SJM', 'Svalbard y Jan Mayen');
INSERT INTO DIC_Pais VALUES (211, 764, 'TH', 'THA', 'Tailandia');
INSERT INTO DIC_Pais VALUES (212, 158, 'TW', 'TWN', 'Taiwán');
INSERT INTO DIC_Pais VALUES (213, 834, 'TZ', 'TZA', 'Tanzania');
INSERT INTO DIC_Pais VALUES (214, 762, 'TJ', 'TJK', 'Tayikistán');
INSERT INTO DIC_Pais VALUES (215, 86, 'IO', 'IOT', 'Territorio Británico del Océano Índico');
INSERT INTO DIC_Pais VALUES (216, 260, 'TF', 'ATF', 'Territorios Australes Franceses');
INSERT INTO DIC_Pais VALUES (217, 626, 'TL', 'TLS', 'Timor Oriental');
INSERT INTO DIC_Pais VALUES (218, 768, 'TG', 'TGO', 'Togo');
INSERT INTO DIC_Pais VALUES (219, 772, 'TK', 'TKL', 'Tokelau');
INSERT INTO DIC_Pais VALUES (220, 776, 'TO', 'TON', 'Tonga');
INSERT INTO DIC_Pais VALUES (221, 780, 'TT', 'TTO', 'Trinidad y Tobago');
INSERT INTO DIC_Pais VALUES (222, 788, 'TN', 'TUN', 'Túnez');
INSERT INTO DIC_Pais VALUES (223, 796, 'TC', 'TCA', 'Islas Turcas y Caicos');
INSERT INTO DIC_Pais VALUES (224, 795, 'TM', 'TKM', 'Turkmenistán');
INSERT INTO DIC_Pais VALUES (225, 792, 'TR', 'TUR', 'Turquía');
INSERT INTO DIC_Pais VALUES (226, 798, 'TV', 'TUV', 'Tuvalu');
INSERT INTO DIC_Pais VALUES (227, 804, 'UA', 'UKR', 'Ucrania');
INSERT INTO DIC_Pais VALUES (228, 800, 'UG', 'UGA', 'Uganda');
INSERT INTO DIC_Pais VALUES (229, 858, 'UY', 'URY', 'Uruguay');
INSERT INTO DIC_Pais VALUES (230, 860, 'UZ', 'UZB', 'Uzbekistán');
INSERT INTO DIC_Pais VALUES (231, 548, 'VU', 'VUT', 'Vanuatu');
INSERT INTO DIC_Pais VALUES (232, 862, 'VE', 'VEN', 'Venezuela');
INSERT INTO DIC_Pais VALUES (233, 704, 'VN', 'VNM', 'Vietnam');
INSERT INTO DIC_Pais VALUES (234, 92, 'VG', 'VGB', 'Islas Vírgenes Británicas');
INSERT INTO DIC_Pais VALUES (235, 850, 'VI', 'VIR', 'Islas Vírgenes de los Estados Unidos');
INSERT INTO DIC_Pais VALUES (236, 876, 'WF', 'WLF', 'Wallis y Futuna');
INSERT INTO DIC_Pais VALUES (237, 887, 'YE', 'YEM', 'Yemen');
INSERT INTO DIC_Pais VALUES (238, 262, 'DJ', 'DJI', 'Yibuti');
INSERT INTO DIC_Pais VALUES (239, 894, 'ZM', 'ZMB', 'Zambia');
INSERT INTO DIC_Pais VALUES (240, 716, 'ZW', 'ZWE', 'Zimbabue');

Fuente aqui



No hay comentarios:

Publicar un comentario