The following script will insert Countries in a Countries lookup table.
The script is assuming SQL server where the ID is an Identity column.
The Table Countries has two columns (“ID” (identity) and “Country” (varchar))
=======================
INSERT INTO COUNTRIES(NAME) VALUES(‘Afghanistan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Albania’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Algeria’);
INSERT INTO COUNTRIES(NAME) VALUES(‘American Samoa’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Andorra’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Angola’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Anguilla’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Antarctica’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Antigua and Barbuda’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Argentina’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Armenia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Aruba’);
INSERT INTO COUNTRIES(NAME) VALUES(‘ustralia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Austria’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Azerbaijan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bahamas’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bahrain’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bangladesh’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Barbados’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Belarus ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Belgium ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Belize’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Benin’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bermuda’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bhutan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bolivia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bosnia and Herzegowina’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Botswana’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bouvet Island’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Brazil’);
INSERT INTO COUNTRIES(NAME) VALUES(‘British Indian Ocean’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Brunei Darussalam’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bulgaria’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Burkina Faso ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Burundi’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cambodia ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cameroon ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘anada’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cape Verde’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cayman Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Central African Republic’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Chad’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Chile’);
INSERT INTO COUNTRIES(NAME) VALUES(‘China’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Christmas Island’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cocos (Keeling) Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Colombia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Comoros’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Congo (Democratic Republic of the)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Congo (Republic of the)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cook islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Costa Rica’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cote dIvoire (Ivory Coast)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Croatia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cuba’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Curaco’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cyprus’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cyprus (Turkish Republic of Northern)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Czech Republic’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Denmark’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Djibouti ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Dominica’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Dominican Republic’);
INSERT INTO COUNTRIES(NAME) VALUES(‘East Timor’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Ecuador’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Egypt’);
INSERT INTO COUNTRIES(NAME) VALUES(‘El Salvador’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Equatorial Guinea’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Eritrea’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Estonia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Ethiopia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Falkland Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Faroe Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Fiji’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Finland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘France’);
INSERT INTO COUNTRIES(NAME) VALUES(‘France, Metropolitan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘French Guiana ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘French Polynesia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘French Southern Territories’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Gabon’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Gambia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Georgia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Germany ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Ghana’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Gibraltar’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Greece’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Greenland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Grenada’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Guadeloupe’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Guam’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Guatemala’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Guinea’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Guinea-Bissau’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Guyana’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Haiti’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Heard and Mc Donald Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Honduras’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Hong Kong’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Hungary’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Iceland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘India’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Indonesia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Iran’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Iraq ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Ireland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Israel’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Italy’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Jamaica’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Japan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Jordan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Kazakhstan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Kenya’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Kiribati ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Korea, Republic of (south)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Kosovo’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Kuwait’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Kyrgyzstan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Laos (Lao Peoples Democratic Republic)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Latvia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Lebanon’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Lesotho’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Liberia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Libyan Arab Jamahiriya’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Liechtenstein’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Lithuania’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Luxembourg’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Macau’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Macedonia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Madagascar’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Malawi’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Malaysia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Maldives’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mali’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Malta’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Marshall Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Martinique ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mauritania’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mauritius’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mayotte’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mexico’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Micronesia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Moldova’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Monaco’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mongolia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Montenegro’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Montserrat’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Morocco’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mozambique’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Myanmar’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Namibia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Nauru’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Nepal’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Netherlands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Netherlands Antilles’);
INSERT INTO COUNTRIES(NAME) VALUES(‘New Caledonia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘New Zealand’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Nicaragua’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Niger’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Nigeria’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Niue’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Norfolk Island’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Northern Mariana Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Norway’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Oman’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Pakistan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Palau’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Palestine’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Panama’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Papua New Guinea’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Paraguay ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Peru’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Philippines’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Pitcairn’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Poland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Portugal’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Puerto Rico’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Qatar’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Reunion’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Romania’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Russian Federation’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Rwanda’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Helena (UK)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Kitts and Nevis’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Lucia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Maarten’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Pierre and Miquelon (FR)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Thomas’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Vincent and the Grenadines’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Samoa’);
INSERT INTO COUNTRIES(NAME) VALUES(‘San Marino’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Sao Tome and Principe’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saudi Arabia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Senegal’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Serbia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Serbia + Montenegro (old)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Seychelles’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Sierra Leone’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Singapore’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Slovakia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Slovenia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Solomon Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Somalia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘South Africa’);
INSERT INTO COUNTRIES(NAME) VALUES(‘South Georgia and the South Sandwich Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Spain’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Sri Lanka’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Sudan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Suriname’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Svalbard and Jan Mayen Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Swaziland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Sweden’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Switzerland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Syrian Arab Republic’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Taiwan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Tajikistan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Tanzania’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Thailand’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Timor-Leste’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Togo’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Tokelau’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Tonga’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Trinidad and Tobago’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Tunisia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Turkey’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Turkmenistan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Turks and Caicos Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Tuvalu’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Uganda’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Ukraine’);
INSERT INTO COUNTRIES(NAME) VALUES(‘United Arab Emirates’);
INSERT INTO COUNTRIES(NAME) VALUES(‘United Kingdom’);
INSERT INTO COUNTRIES(NAME) VALUES(‘United States of America’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Uruguay’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Uzbekistan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Vanuatu’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Vatican City State’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Venezuela’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Vietnam’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Virgin Islands (British)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Virgin Islands (U.S.)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Wallis and Futuna Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Western Sahara’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Yemen’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Zaire’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Zambia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Zimbabwe’);
Emad's Blog 
Would have been very useful if there was another table called Continents so that you can tell which continent each country belongs to.
I have doubt about Three countries spelling
I think first is Netherlands and the last is Sweden
INSERT INTO COUNTRIES(NAME) VALUES(‘therlands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘t Enumerated’);
INSERT INTO COUNTRIES(NAME) VALUES(‘eden’);
@waqas:
Thanks for the note. I have fixed it.
Thanks for the script
I think thiso ne miss lots of country
i did this one it’s help more..
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘AFGHANISTAN’,’AF’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ALAND ISLANDS’,’AX’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ALBANIA’,’AL’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ALGERIA’,’DZ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘AMERICAN SAMOA’,’AS’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ANDORRA’,’AD’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ANGOLA’,’AO’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ANGUILLA’,’AI’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ANTARCTICA’,’AQ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ANTIGUA AND BARBUDA’,’AG’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ARGENTINA’,’AR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ARMENIA’,’AM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ARUBA’,’AW’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘AUSTRALIA’,’AU’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘AUSTRIA’,’AT’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘AZERBAIJAN’,’AZ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BAHAMAS’,’BS’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BAHRAIN’,’BH’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BANGLADESH’,’BD’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BARBADOS’,’BB’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BELARUS’,’BY’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BELGIUM’,’BE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BELIZE’,’BZ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BENIN’,’BJ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BERMUDA’,’BM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BHUTAN’,’BT’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BOLIVIA’,’BO’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BONAIRE’,’BQ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BOSNIA AND HERZEGOVINA’,’BA’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BOTSWANA’,’BW’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BOUVET ISLAND’,’BV’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BRAZIL’,’BR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BRITISH INDIAN OCEAN TERRITORY’,’IO’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BRUNEI DARUSSALAM’,’BN’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BULGARIA’,’BG’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BURKINA FASO’,’BF’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘BURUNDI’,’BI’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CAMBODIA’,’KH’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CAMEROON’,’CM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CANADA’,’CA’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CAPE VERDE’,’CV’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CAYMAN ISLANDS’,’KY’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CENTRAL AFRICAN REPUBLIC’,’CF’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CHAD’,’TD’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CHILE’,’CL’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CHINA’,’CN’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CHRISTMAS ISLAND’,’CX’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘COCOS (KEELING) ISLANDS’,’CC’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘COLOMBIA’,’CO’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘COMOROS’,’KM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CONGO’,’CG’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CONGO’,’CD’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘COOK ISLANDS’,’CK’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘COSTA RICA’,’CR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘Cote dIvoire’,’CI’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CROATIA’,’HR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CUBA’,’CU’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CURAÇAO’,’CW’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CYPRUS’,’CY’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘CZECH REPUBLIC’,’CZ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘DENMARK’,’DK’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘DJIBOUTI’,’DJ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘DOMINICA’,’DM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘DOMINICAN REPUBLIC’,’DO’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ECUADOR’,’EC’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘EGYPT’,’EG’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘EL SALVADOR’,’SV’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘EQUATORIAL GUINEA’,’GQ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ERITREA’,’ER’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ESTONIA’,’EE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ETHIOPIA’,’ET’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘FALKLAND ISLANDS (MALVINAS)’,’FK’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘FAROE ISLANDS’,’FO’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘FIJI’,’FJ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘FINLAND’,’FI’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘FRANCE’,’FR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘FRENCH GUIANA’,’GF’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘FRENCH POLYNESIA’,’PF’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘FRENCH SOUTHERN TERRITORIES’,’TF’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GABON’,’GA’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GAMBIA’,’GM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GEORGIA’,’GE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GERMANY’,’DE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GHANA’,’GH’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GIBRALTAR’,’GI’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GREECE’,’GR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GREENLAND’,’GL’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GRENADA’,’GD’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GUADELOUPE’,’GP’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GUAM’,’GU’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GUATEMALA’,’GT’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GUERNSEY’,’GG’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GUINEA’,’GN’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GUINEA-BISSAU’,’GW’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘GUYANA’,’GY’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘HAITI’,’HT’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘HEARD AND MCDONALD ISLANDS’,’HM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘HOLY SEE’,’VA’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘HONDURAS’,’HN’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘HONG KONG’,’HK’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘HUNGARY’,’HU’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ICELAND’,’IS’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘INDIA’,’IN’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘INDONESIA’,’ID’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘IRAN’,’IR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘IRAQ’,’IQ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘IRELAND’,’IE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ISLE OF MAN’,’IM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ISRAEL’,’IL’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ITALY’,’IT’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘JAMAICA’,’JM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘JAPAN’,’JP’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘JERSEY’,’JE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘JORDAN’,’JO’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘KAZAKHSTAN’,’KZ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘KENYA’,’KE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘KIRIBATI’,’KI’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘KOREA’,’KP’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘KOREA’,’KR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘KUWAIT’,’KW’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘KYRGYZSTAN’,’KG’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘LAO PEOPLES DEMOCRATIC REPUBLIC’,’LA’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘LATVIA’,’LV’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘LEBANON’,’LB’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘LESOTHO’,’LS’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘LIBERIA’,’LR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘LIBYAN ARAB JAMAHIRIYA’,’LY’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘LIECHTENSTEIN’,’LI’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘LITHUANIA’,’LT’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘LUXEMBOURG’,’LU’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MACAO’,’MO’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MACEDONIA’,’MK’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MADAGASCAR’,’MG’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MALAWI’,’MW’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MALAYSIA;MY’,”);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MALDIVES’,’MV’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MALI’,’ML’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MALTA’,’MT’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MARSHALL ISLANDS’,’MH’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MARTINIQUE’,’MQ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MAURITANIA’,’MR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MAURITIUS’,’MU’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MAYOTTE’,’YT’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MEXICO’,’MX’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MICRONESIA’,’FM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MOLDOVA’,’MD’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MONACO’,’MC’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MONGOLIA’,’MN’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MONTENEGRO’,’ME’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MONTSERRAT’,’MS’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MOROCCO’,’MA’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MOZAMBIQUE’,’MZ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘MYANMAR’,’MM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘NAMIBIA’,’NA’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘NAURU’,’NR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘NEPAL’,’NP’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘NETHERLANDS’,’NL’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘NEW CALEDONIA’,’NC’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘NEW ZEALAND’,’NZ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘NICARAGUA’,’NI’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘NIGER’,’NE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘NIGERIA’,’NG’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘NIUE’,’NU’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘NORFOLK ISLAND’,’NF’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘NORTHERN MARIANA ISLANDS’,’MP’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘NORWAY’,’NO’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘OMAN’,’OM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘PAKISTAN’,’PK’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘PALAU’,’PW’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘PALESTINIAN’,’PS’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘PANAMA’,’PA’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘PAPUA NEW GUINEA’,’PG’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘PARAGUAY’,’PY’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘PERU’,’PE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘PHILIPPINES’,’PH’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘PITCAIRN’,’PN’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘POLAND’,’PL’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘PORTUGAL’,’PT’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘PUERTO RICO’,’PR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘QATAR’,’QA’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘RÉUNION’,’RE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ROMANIA’,’RO’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘RUSSIAN FEDERATION’,’RU’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘RWANDA’,’RW’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SAINT BARTHÉLEMY’,’BL’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SAINT HELENA’,’SH’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SAINT KITTS AND NEVIS’,’KN’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SAINT LUCIA’,’LC’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SAINT MARTIN (FRENCH PART)’,’MF’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SAINT PIERRE AND MIQUELON’,’PM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SAINT VINCENT AND THE GRENADINES’,’VC’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SAMOA’,’WS’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SAN MARINO’,’SM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SAO TOME AND PRINCIPE’,’ST’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SAUDI ARABIA’,’SA’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SENEGAL’,’SN’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SERBIA’,’RS’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SEYCHELLES’,’SC’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SIERRA LEONE’,’SL’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SINGAPORE’,’SG’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SINT MAARTEN (DUTCH PART)’,’SX’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SLOVAKIA’,’SK’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SLOVENIA’,’SI’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SOLOMON ISLANDS’,’SB’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SOMALIA’,’SO’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SOUTH AFRICA’,’ZA’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS’,’GS’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SPAIN’,’ES’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SRI LANKA’,’LK’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SUDAN’,’SD’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SURINAME’,’SR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SVALBARD AND JAN MAYEN’,’SJ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SWAZILAND’,’SZ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SWEDEN’,’SE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SWITZERLAND’,’CH’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘SYRIAN ARAB REPUBLIC’,’SY’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘TAIWAN, PROVINCE OF CHINA’,’TW’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘TAJIKISTAN’,’TJ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘TANZANIA, UNITED REPUBLIC OF’,’TZ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘THAILAND’,’TH’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘TIMOR-LESTE’,’TL’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘TOGO’,’TG’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘TOKELAU’,’TK’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘TONGA’,’TO’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘TRINIDAD AND TOBAGO’,’TT’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘TUNISIA’,’TN’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘TURKEY’,’TR’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘TURKMENISTAN’,’TM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘TURKS AND CAICOS ISLANDS’,’TC’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘TUVALU’,’TV’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘UGANDA’,’UG’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘UKRAINE’,’UA’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘UNITED ARAB EMIRATES’,’AE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘UNITED KINGDOM’,’GB’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘UNITED STATES’,’US’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘UNITED STATES MINOR OUTLYING ISLANDS’,’UM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘URUGUAY’,’UY’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘UZBEKISTAN’,’UZ’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘VANUATU’,’VU’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘VENEZUELA’,’VE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘VIET NAM’,’VN’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘VIRGIN ISLANDS, BRITISH’,’VG’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘VIRGIN ISLANDS, U.S.’,’VI’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘WALLIS AND FUTUNA’,’WF’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘WESTERN SAHARA’,’EH’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘YEMEN’,’YE’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ZAMBIA’,’ZM’);
INSERT INTO [dbo].[tbl_CountryInfo]([CountryName],[CountryCode])VALUES(‘ZIMBABWE’,’ZW’);
Guys what about states list…. Do something..
It’s an amazing article for all the web people; they will obtain benefit from it I am sure.
I’m very pleased to discover this website. I wanted to thank you for your time just for this wonderful read!! I definitely liked every part of it and I have you saved as a favorite to look at new things on your website.