Skip to main content

MS SQL commands for inserting country list in database

Image
By
I was having a hard time to find a database with complete set of country list and its corresponding nationalities... Although I found some but probably they are for sale... and you need to buy it (>.<) ...

So what I've only got (from web surfing / researching) was a text file of country list plus their nationalities. So I don't have any option, so I've created a MS SQL query commands that inserts all 192 countries in a database..by just creating a new script , I mean I coded it into an MS SQL queries that inserts into a table(so you won't need to type it (^.~) ).

Here is the instructions :

1) Download or copy the Query / Scripts I provided.

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Afghanistan', 'Afghan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Albania', 'Albanian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Algeria', 'Algerian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Andorra', 'Andorran')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Angola', 'Angolan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Antigua and Barbuda', 'Antiguans, Barbudans')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Argentina', 'Argentinean')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Armenia', 'Armenian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Australia', 'Australian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Austria', 'Austrian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Azerbaijan', 'Azerbaijani')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('The Bahamas', 'Bahamian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bahrain', 'Bahraini')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bangladesh', 'Bangladeshi')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Barbados', 'Barbadian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Belarus', 'Belarusian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Belgium', 'Belgian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Belize', 'Belizean')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Benin', 'Beninese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bhutan', 'Bhutanese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bolivia', 'Bolivian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Bosnia and Herzegovina', 'Bosnian, Herzegovinian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Botswana', 'Motswana (singular), Batswana (plural)')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values('Brazil', 'Brazilian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Brunei', 'Bruneian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Bulgaria', 'Bulgarian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Burkina Faso', 'Burkinabe')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Burundi', 'Burundian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cambodia', 'Cambodian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cameroon', 'Cameroonian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Canada', 'Canadian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cape Verde', 'Cape Verdian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Central African Republic', 'Central African')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Chad', 'Chadian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Chile', 'Chilean')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'China', 'Chinese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Colombia', 'Colombian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Comoros', 'Comoran')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Congo, Republic of the', 'Congolese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Congo, Democratic Republic of the', 'Congolese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Costa Rica', 'Costa Rican')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cote d”Ivoire', 'Ivorian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Croatia', 'Croatian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cuba', 'Cuban')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Cyprus', 'Cypriot')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Czech Republic', 'Czech')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Denmark', 'Danish')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Djibouti', 'Djibouti')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Dominica', 'Dominican')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Dominican Republic', 'Dominican')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'East Timor', 'East Timorese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ecuador', 'Ecuadorean')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Egypt', 'Egyptian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'El Salvador', 'Salvadoran')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Equatorial Guinea', 'Equatorial Guinean')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Eritrea', 'Eritrean')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Estonia', 'Estonian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ethiopia', 'Ethiopian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Fiji', 'Fijian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Finland', 'Finnish')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'France', 'French')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Gabon', 'Gabonese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'The Gambia', 'Gambian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Georgia', 'Georgian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Germany', 'German')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ghana', 'Ghanaian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Greece', 'Greek')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Grenada', 'Grenadian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Guatemala', 'Guatemalan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Guinea', 'Guinean')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Guinea-Bissau', 'Guinea-Bissauan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Guyana', 'Guyanese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Haiti', 'Haitian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Honduras', 'Honduran')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Hungary', 'Hungarian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Iceland', 'Icelander')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'India', 'Indian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Indonesia', 'Indonesian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Iran', 'Iranian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Iraq', 'Iraqi')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ireland', 'Irish')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Israel', 'Israeli')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Italy', 'Italian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Jamaica', 'Jamaican')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Japan', 'Japanese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Jordan', 'Jordanian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kazakhstan', 'Kazakhstani')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kenya', 'Kenyan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kiribati', 'I-Kiribati')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Korea, North', 'North Korean')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Korea, South', 'South Korean')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kuwait', 'Kuwaiti')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Kyrgyz Republic', 'Kirghiz')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Laos', 'Laotian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Latvia', 'Latvian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Lebanon', 'Lebanese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Lesotho', 'Mosotho')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Liberia', 'Liberian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Libya', 'Libyan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Liechtenstein', 'Liechtensteiner')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Lithuania', 'Lithuanian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Luxembourg', 'Luxembourger')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Macedonia', 'Macedonian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Madagascar', 'Malagasy')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Malawi', 'Malawian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Malaysia', 'Malaysian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Maldives', 'Maldivan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mali', 'Malian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Malta', 'Maltese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Marshall Islands', 'Marshallese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mauritania', 'Mauritanian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mauritius', 'Mauritian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mexico', 'Mexican')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Federated States of Micronesia', 'Micronesian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Moldova', 'Moldovan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Monaco', 'Monegasque')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mongolia', 'Mongolian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Morocco', 'Moroccan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Mozambique', 'Mozambican')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Myanmar (Burma)', 'Burmese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Namibia', 'Namibian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Nauru', 'Nauruan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Nepal', 'Nepalese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Netherlands', 'Dutch')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'New Zealand', 'New Zealander')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Nicaragua', 'Nicaraguan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Niger', 'Nigerien')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Nigeria', 'Nigerian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Norway', 'Norwegian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Oman', 'Omani')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Pakistan', 'Pakistani')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Palau', 'Palauan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Panama', 'Panamanian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Papua New Guinea', 'Papua New Guinean')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Paraguay', 'Paraguayan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Peru', 'Peruvian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Philippines', 'Filipino')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Poland', 'Polish')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Portugal', 'Portuguese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Qatar', 'Qatari')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Romania', 'Romanian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Russia', 'Russian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Rwanda', 'Rwandan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Saint Kitts and Nevis', 'Kittian and Nevisian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Saint Lucia', 'Saint Lucian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Samoa', 'Samoan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'San Marino', 'Sammarinese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sao Tome and Principe', 'Sao Tomean')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Saudi Arabia', 'Saudi Arabian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Senegal', 'Senegalese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Serbia and Montenegro', 'Serbian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Seychelles', 'Seychellois')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sierra Leone', 'Sierra Leonean')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Singapore', 'Singaporean')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Slovakia', 'Slovak')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Slovenia', 'Slovene')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Solomon Islands', 'Solomon Islander')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Somalia', 'Somali')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'South Africa', 'South African')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Spain', 'Spanish')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sri Lanka', 'Sri Lankan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sudan', 'Sudanese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Suriname', 'Surinamer')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Swaziland', 'Swazi')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Sweden', 'Swedish')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Switzerland', 'Swiss')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Syria', 'Syrian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Taiwan', 'Taiwanese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tajikistan', 'Tadzhik')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tanzania', 'Tanzanian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Thailand', 'Thai')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Togo', 'Togolese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tonga', 'Tongan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Trinidad and Tobago', 'Trinidadian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tunisia', 'Tunisian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Turkey', 'Turkish')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Turkmenistan', 'Turkmen')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Tuvalu', 'Tuvaluan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Uganda', 'Ugandan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Ukraine', 'Ukrainian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'United Arab Emirates', 'Emirian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'United Kingdom', 'British')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values ('United States', 'American')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Uruguay', 'Uruguayan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Uzbekistan', 'Uzbekistani')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Vanuatu', 'Ni-Vanuatu')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Vatican City (Holy See)', 'none')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Venezuela', 'Venezuelan')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Vietnam', 'Vietnamese')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Yemen', 'Yemeni')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Zambia', 'Zambian')

INSERT INTO COUNTRY([NAME] , NATIONALITY )
values( 'Zimbabwe', 'Zimbabwean')









2) On your MS SQL Enterprise manager(2000 ot later) , then look for your database where you want to place the table for Country

3)Create a table namely "Country"

4) Add the following fields on your table :

* CountryID - You may opt to this as your primary key and make it default value into AUTONUMER or by doing that just make it as Identity Seed = "Yes"

*Name - Country Name
*Nationality - Nationality that corresponds to County

Note : you may add other fields aside from the 3 fields I provided, just be sure to set all fields with default values

5)Save the table and label it with "Country"

6)Go to SQL Query analyzer

7) Open the Script or Copy the Scripts/SQL Commands

8) Paste it at the Query analyzer

9) Finally, Press "F5"

10) Then viola! select your "Country" table , in this way "SELECT * FROM COUNTRY"



I Hope this might help (^_^)!

Comments

Post a Comment

Popular posts from this blog

My Carboxy Stretchmark Treatment and Slimming Wrap experience at Total Skin Care Center

By
I've been googling around about this new treatment being introduced and implemented lately that is called Carboxytherapy that helps to reduce fats, cellulites deposits & even skin stretchmarks in our body.  ===================================== ======================================= According to this site : http://www.carboxytherapy.com/ Carboxytherapy refers to the cutaneous and subcutaneous administration of carbon dioxide gas [CO2] for therapeutic purposes. Carboxytherapy originated at the Royal Spas of France in 1932 with the treatment of patients afflicted by peripheral arterial occlusive disease. In South America and Europe, carbon dioxide therapy has been applied to the treatment of stretch marks, cellulite, and hypertrophic scars with impressive results. Studies have demonstrated that carboxytherapy improves skin elasticity, improves circulation, encourages collagen repair, improves the appearance of fine lines and wrinkles, and destroys localized fatty depos...
14 comments
Read more

ALERT! : Conficker Worm

By
National Cyber Alert System Technical Cyber Security Alert TA09-088A Conficker Worm Targets Microsoft Windows Systems Original release date: March 29, 2009 Last revised: March 30, 2009 Source: US-CERT Systems Affected * Microsoft Windows Overview US-CERT is aware of public reports indicating a widespread infection of the Conficker/Downadup worm, which can infect a Microsoft Windows system from a thumb drive, a network share, or directly across a corporate network, if the network servers are not patched with the MS08-067 patch from Microsoft. I. Description Home users can apply a simple test for the presence of a Conficker/Downadup infection on their home computers. The presence of a Conficker/Downadup infection may be detected if a user is unable to surf to their security solution website or if they are unable to connect to the websites, by downloading detection/removal tools available free from those sites: * http://www.symantec.com/norton/theme.jsp?them...
1 comment
Read more