Countries List with Nationality.
February 5th, 2010Here is list of countries with the insert command to be inserted in a table named Country.
after running the whole queries you can bind your table with Combo Box or any other control after that your control will be able to show the Countries list.
Create table COUNTRYLIST (CountryName char(40), Nationality char(40))
Run these queries…
INSERT INTO COUNTRYLIST VALUES (’Afghanistan’,'Afghan’)
INSERT INTO COUNTRYLIST VALUES (’Albania’,'Albanian’)
INSERT INTO COUNTRYLIST VALUES (’Algeria’,'Algerian’)
INSERT INTO COUNTRYLIST VALUES (’Andorra’,'Andorran’)
INSERT INTO COUNTRYLIST VALUES (’Angola’,'Angolan’)
INSERT INTO COUNTRYLIST VALUES (’Antigua and Barbuda’,'Antiguans,
Barbudans’)
INSERT INTO COUNTRYLIST VALUES (’Argentina’,'Argentinean’)
INSERT INTO COUNTRYLIST VALUES (’Armenia’,'Armenian’)
INSERT INTO COUNTRYLIST VALUES (’Australia’,'Australian’)
INSERT INTO COUNTRYLIST VALUES (’Austria’,'Austrian’)
INSERT INTO COUNTRYLIST VALUES (’Azerbaijan’,'Azerbaijani’)
INSERT INTO COUNTRYLIST VALUES (’The Bahamas’,'Bahamian’)
INSERT INTO COUNTRYLIST VALUES (’Bahrain’,'Bahraini’)
INSERT INTO COUNTRYLIST VALUES (’Bangladesh’,'Bangladeshi’)
INSERT INTO COUNTRYLIST VALUES (’Barbados’,'Barbadian’)
INSERT INTO COUNTRYLIST VALUES (’Belarus’,'Belarusian’)
INSERT INTO COUNTRYLIST VALUES (’Belgium’,'Belgian’)
INSERT INTO COUNTRYLIST VALUES (’Belize’,'Belizean’)
INSERT INTO COUNTRYLIST VALUES (’Benin’,'Beninese’)
INSERT INTO COUNTRYLIST VALUES (’Bhutan’,'Bhutanese’)
INSERT INTO COUNTRYLIST VALUES (’Bolivia’,'Bolivian’)
INSERT INTO COUNTRYLIST VALUES (’Bosnia and Herzegovina’,'Bosnian,
Herzegovinian’)
INSERT INTO COUNTRYLIST VALUES (’Botswana’,'Motswana (singular), Batswana
(plural)’)
INSERT INTO COUNTRYLIST VALUES (’Brazil’,'Brazilian’)
INSERT INTO COUNTRYLIST VALUES (’Brunei’,'Bruneian’)
INSERT INTO COUNTRYLIST VALUES (’Bulgaria’,'Bulgarian’)
INSERT INTO COUNTRYLIST VALUES (’Burkina Faso’,'Burkinabe’)
INSERT INTO COUNTRYLIST VALUES (’Burundi’,'Burundian’)
INSERT INTO COUNTRYLIST VALUES (’Cambodia’,'Cambodian’)
INSERT INTO COUNTRYLIST VALUES (’Cameroon’,'Cameroonian’)
INSERT INTO COUNTRYLIST VALUES (’Canada’,'Canadian’)
INSERT INTO COUNTRYLIST VALUES (’Cape Verde’,'Cape Verdian’)
INSERT INTO COUNTRYLIST VALUES (’Central African Republic’,'Central African’)
INSERT INTO COUNTRYLIST VALUES (’Chad’,'Chadian’)
INSERT INTO COUNTRYLIST VALUES (’Chile’,'Chilean’)
INSERT INTO COUNTRYLIST VALUES (’China’,'Chinese’)
INSERT INTO COUNTRYLIST VALUES (’Colombia’,'Colombian’)
INSERT INTO COUNTRYLIST VALUES (’Comoros’,'Comoran’)
INSERT INTO COUNTRYLIST VALUES (’Congo, Republic of the’,'Congolese’)
INSERT INTO COUNTRYLIST VALUES (’Congo, Democratic Republic of
the’,'Congolese’)
INSERT INTO COUNTRYLIST VALUES (’Costa Rica’,'Costa Rican’)
INSERT INTO COUNTRYLIST VALUES (’Cote d”Ivoire’,'Ivorian’)
INSERT INTO COUNTRYLIST VALUES (’Croatia’,'Croatian’)
INSERT INTO COUNTRYLIST VALUES (’Cuba’,'Cuban’)
INSERT INTO COUNTRYLIST VALUES (’Cyprus’,'Cypriot’)
INSERT INTO COUNTRYLIST VALUES (’Czech Republic’,'Czech’)
INSERT INTO COUNTRYLIST VALUES (’Denmark’,'Danish’)
INSERT INTO COUNTRYLIST VALUES (’Djibouti’,'Djibouti’)
INSERT INTO COUNTRYLIST VALUES (’Dominica’,'Dominican’)
INSERT INTO COUNTRYLIST VALUES (’Dominican Republic’,'Dominican’)
INSERT INTO COUNTRYLIST VALUES (’East Timor’,'East Timorese’)
INSERT INTO COUNTRYLIST VALUES (’Ecuador’,'Ecuadorean’)
INSERT INTO COUNTRYLIST VALUES (’Egypt’,'Egyptian’)
INSERT INTO COUNTRYLIST VALUES (’El Salvador’,'Salvadoran’)
INSERT INTO COUNTRYLIST VALUES (’Equatorial Guinea’,'Equatorial Guinean’)
INSERT INTO COUNTRYLIST VALUES (’Eritrea’,'Eritrean’)
INSERT INTO COUNTRYLIST VALUES (’Estonia’,'Estonian’)
INSERT INTO COUNTRYLIST VALUES (’Ethiopia’,'Ethiopian’)
INSERT INTO COUNTRYLIST VALUES (’Fiji’,'Fijian’)
INSERT INTO COUNTRYLIST VALUES (’Finland’,'Finnish’)
INSERT INTO COUNTRYLIST VALUES (’France’,'French’)
INSERT INTO COUNTRYLIST VALUES (’Gabon’,'Gabonese’)
INSERT INTO COUNTRYLIST VALUES (’The Gambia’,'Gambian’)
INSERT INTO COUNTRYLIST VALUES (’Georgia’,'Georgian’)
INSERT INTO COUNTRYLIST VALUES (’Germany’,'German’)
INSERT INTO COUNTRYLIST VALUES (’Ghana’,'Ghanaian’)
INSERT INTO COUNTRYLIST VALUES (’Greece’,'Greek’)
INSERT INTO COUNTRYLIST VALUES (’Grenada’,'Grenadian’)
INSERT INTO COUNTRYLIST VALUES (’Guatemala’,'Guatemalan’)
INSERT INTO COUNTRYLIST VALUES (’Guinea’,'Guinean’)
INSERT INTO COUNTRYLIST VALUES (’Guinea-Bissau’,'Guinea-Bissauan’)
INSERT INTO COUNTRYLIST VALUES (’Guyana’,'Guyanese’)
INSERT INTO COUNTRYLIST VALUES (’Haiti’,'Haitian’)
INSERT INTO COUNTRYLIST VALUES (’Honduras’,'Honduran’)
INSERT INTO COUNTRYLIST VALUES (’Hungary’,'Hungarian’)
INSERT INTO COUNTRYLIST VALUES (’Iceland’,'Icelander’)
INSERT INTO COUNTRYLIST VALUES (’India’,'Indian’)
INSERT INTO COUNTRYLIST VALUES (’Indonesia’,'Indonesian’)
INSERT INTO COUNTRYLIST VALUES (’Iran’,'Iranian’)
INSERT INTO COUNTRYLIST VALUES (’Iraq’,'Iraqi’)
INSERT INTO COUNTRYLIST VALUES (’Ireland’,'Irish’)
INSERT INTO COUNTRYLIST VALUES (’Israel’,'Israeli’)
INSERT INTO COUNTRYLIST VALUES (’Italy’,'Italian’)
INSERT INTO COUNTRYLIST VALUES (’Jamaica’,'Jamaican’)
INSERT INTO COUNTRYLIST VALUES (’Japan’,'Japanese’)
INSERT INTO COUNTRYLIST VALUES (’Jordan’,'Jordanian’)
INSERT INTO COUNTRYLIST VALUES (’Kazakhstan’,'Kazakhstani’)
INSERT INTO COUNTRYLIST VALUES (’Kenya’,'Kenyan’)
INSERT INTO COUNTRYLIST VALUES (’Kiribati’,'I-Kiribati’)
INSERT INTO COUNTRYLIST VALUES (’Korea, North’,'North Korean’)
INSERT INTO COUNTRYLIST VALUES (’Korea, South’,'South Korean’)
INSERT INTO COUNTRYLIST VALUES (’Kuwait’,'Kuwaiti’)
INSERT INTO COUNTRYLIST VALUES (’Kyrgyz Republic’,'Kirghiz’)
INSERT INTO COUNTRYLIST VALUES (’Laos’,'Laotian’)
INSERT INTO COUNTRYLIST VALUES (’Latvia’,'Latvian’)
INSERT INTO COUNTRYLIST VALUES (’Lebanon’,'Lebanese’)
INSERT INTO COUNTRYLIST VALUES (’Lesotho’,'Mosotho’)
INSERT INTO COUNTRYLIST VALUES (’Liberia’,'Liberian’)
INSERT INTO COUNTRYLIST VALUES (’Libya’,'Libyan’)
INSERT INTO COUNTRYLIST VALUES (’Liechtenstein’,'Liechtensteiner’)
INSERT INTO COUNTRYLIST VALUES (’Lithuania’,'Lithuanian’)
INSERT INTO COUNTRYLIST VALUES (’Luxembourg’,'Luxembourger’)
INSERT INTO COUNTRYLIST VALUES (’Macedonia’,'Macedonian’)
INSERT INTO COUNTRYLIST VALUES (’Madagascar’,'Malagasy’)
INSERT INTO COUNTRYLIST VALUES (’Malawi’,'Malawian’)
INSERT INTO COUNTRYLIST VALUES (’Malaysia’,'Malaysian’)
INSERT INTO COUNTRYLIST VALUES (’Maldives’,'Maldivan’)
INSERT INTO COUNTRYLIST VALUES (’Mali’,'Malian’)
INSERT INTO COUNTRYLIST VALUES (’Malta’,'Maltese’)
INSERT INTO COUNTRYLIST VALUES (’Marshall Islands’,'Marshallese’)
INSERT INTO COUNTRYLIST VALUES (’Mauritania’,'Mauritanian’)
INSERT INTO COUNTRYLIST VALUES (’Mauritius’,'Mauritian’)
INSERT INTO COUNTRYLIST VALUES (’Mexico’,'Mexican’)
INSERT INTO COUNTRYLIST VALUES (’Federated States of
Micronesia’,'Micronesian’)
INSERT INTO COUNTRYLIST VALUES (’Moldova’,'Moldovan’)
INSERT INTO COUNTRYLIST VALUES (’Monaco’,'Monegasque’)
INSERT INTO COUNTRYLIST VALUES (’Mongolia’,'Mongolian’)
INSERT INTO COUNTRYLIST VALUES (’Morocco’,'Moroccan’)
INSERT INTO COUNTRYLIST VALUES (’Mozambique’,'Mozambican’)
INSERT INTO COUNTRYLIST VALUES (’Myanmar (Burma)’,'Burmese’)
INSERT INTO COUNTRYLIST VALUES (’Namibia’,'Namibian’)
INSERT INTO COUNTRYLIST VALUES (’Nauru’,'Nauruan’)
INSERT INTO COUNTRYLIST VALUES (’Nepal’,'Nepalese’)
INSERT INTO COUNTRYLIST VALUES (’Netherlands’,'Dutch’)
INSERT INTO COUNTRYLIST VALUES (’New Zealand’,'New Zealander’)
INSERT INTO COUNTRYLIST VALUES (’Nicaragua’,'Nicaraguan’)
INSERT INTO COUNTRYLIST VALUES (’Niger’,'Nigerien’)
INSERT INTO COUNTRYLIST VALUES (’Nigeria’,'Nigerian’)
INSERT INTO COUNTRYLIST VALUES (’Norway’,'Norwegian’)
INSERT INTO COUNTRYLIST VALUES (’Oman’,'Omani’)
INSERT INTO COUNTRYLIST VALUES (’Pakistan’,'Pakistani’)
INSERT INTO COUNTRYLIST VALUES (’Palau’,'Palauan’)
INSERT INTO COUNTRYLIST VALUES (’Panama’,'Panamanian’)
INSERT INTO COUNTRYLIST VALUES (’Papua New Guinea’,'Papua New Guinean’)
INSERT INTO COUNTRYLIST VALUES (’Paraguay’,'Paraguayan’)
INSERT INTO COUNTRYLIST VALUES (’Peru’,'Peruvian’)
INSERT INTO COUNTRYLIST VALUES (’Philippines’,'Filipino’)
INSERT INTO COUNTRYLIST VALUES (’Poland’,'Polish’)
INSERT INTO COUNTRYLIST VALUES (’Portugal’,'Portuguese’)
INSERT INTO COUNTRYLIST VALUES (’Qatar’,'Qatari’)
INSERT INTO COUNTRYLIST VALUES (’Romania’,'Romanian’)
INSERT INTO COUNTRYLIST VALUES (’Russia’,'Russian’)
INSERT INTO COUNTRYLIST VALUES (’Rwanda’,'Rwandan’)
INSERT INTO COUNTRYLIST VALUES (’Saint Kitts and Nevis’,'Kittian and Nevisian’)
INSERT INTO COUNTRYLIST VALUES (’Saint Lucia’,'Saint Lucian’)
INSERT INTO COUNTRYLIST VALUES (’Samoa’,'Samoan’)
INSERT INTO COUNTRYLIST VALUES (’San Marino’,'Sammarinese’)
INSERT INTO COUNTRYLIST VALUES (’Sao Tome and Principe’,'Sao Tomean’)
INSERT INTO COUNTRYLIST VALUES (’Saudi Arabia’,'Saudi Arabian’)
INSERT INTO COUNTRYLIST VALUES (’Senegal’,'Senegalese’)
INSERT INTO COUNTRYLIST VALUES (’Serbia and Montenegro’,'Serbian’)
INSERT INTO COUNTRYLIST VALUES (’Seychelles’,'Seychellois’)
INSERT INTO COUNTRYLIST VALUES (’Sierra Leone’,'Sierra Leonean’)
INSERT INTO COUNTRYLIST VALUES (’Singapore’,'Singaporean’)
INSERT INTO COUNTRYLIST VALUES (’Slovakia’,'Slovak’)
INSERT INTO COUNTRYLIST VALUES (’Slovenia’,'Slovene’)
INSERT INTO COUNTRYLIST VALUES (’Solomon Islands’,'Solomon Islander’)
INSERT INTO COUNTRYLIST VALUES (’Somalia’,'Somali’)
INSERT INTO COUNTRYLIST VALUES (’South Africa’,'South African’)
INSERT INTO COUNTRYLIST VALUES (’Spain’,'Spanish’)
INSERT INTO COUNTRYLIST VALUES (’Sri Lanka’,'Sri Lankan’)
INSERT INTO COUNTRYLIST VALUES (’Sudan’,'Sudanese’)
INSERT INTO COUNTRYLIST VALUES (’Suriname’,'Surinamer’)
INSERT INTO COUNTRYLIST VALUES (’Swaziland’,'Swazi’)
INSERT INTO COUNTRYLIST VALUES (’Sweden’,'Swedish’)
INSERT INTO COUNTRYLIST VALUES (’Switzerland’,'Swiss’)
INSERT INTO COUNTRYLIST VALUES (’Syria’,'Syrian’)
INSERT INTO COUNTRYLIST VALUES (’Taiwan’,'Taiwanese’)
INSERT INTO COUNTRYLIST VALUES (’Tajikistan’,'Tadzhik’)
INSERT INTO COUNTRYLIST VALUES (’Tanzania’,'Tanzanian’)
INSERT INTO COUNTRYLIST VALUES (’Thailand’,'Thai’)
INSERT INTO COUNTRYLIST VALUES (’Togo’,'Togolese’)
INSERT INTO COUNTRYLIST VALUES (’Tonga’,'Tongan’)
INSERT INTO COUNTRYLIST VALUES (’Trinidad and Tobago’,'Trinidadian’)
INSERT INTO COUNTRYLIST VALUES (’Tunisia’,'Tunisian’)
INSERT INTO COUNTRYLIST VALUES (’Turkey’,'Turkish’)
INSERT INTO COUNTRYLIST VALUES (’Turkmenistan’,'Turkmen’)
INSERT INTO COUNTRYLIST VALUES (’Tuvalu’,'Tuvaluan’)
INSERT INTO COUNTRYLIST VALUES (’Uganda’,'Ugandan’)
INSERT INTO COUNTRYLIST VALUES (’Ukraine’,'Ukrainian’)
INSERT INTO COUNTRYLIST VALUES (’United Arab Emirates’,'Emirian’)
INSERT INTO COUNTRYLIST VALUES (’United Kingdom’,'British’)
INSERT INTO COUNTRYLIST VALUES (’United States’,'American’)
INSERT INTO COUNTRYLIST VALUES (’Uruguay’,'Uruguayan’)
INSERT INTO COUNTRYLIST VALUES (’Uzbekistan’,'Uzbekistani’)
INSERT INTO COUNTRYLIST VALUES (’Vanuatu’,'Ni-Vanuatu’)
INSERT INTO COUNTRYLIST VALUES (’Vatican City (Holy See)’,'none’)
INSERT INTO COUNTRYLIST VALUES (’Venezuela’,'Venezuelan’)
INSERT INTO COUNTRYLIST VALUES (’Vietnam’,'Vietnamese’)
INSERT INTO COUNTRYLIST VALUES (’Yemen’,'Yemeni’)
INSERT INTO COUNTRYLIST VALUES (’Zambia’,'Zambian’)
INSERT INTO COUNTRYLIST VALUES (’Zimbabwe’,'Zimbabwean’)
Thanks
Nikhil Kumar
|
|
|

Posted by dotnetask 




