Useful SQL Script – Filling Countries table

4:25:00 am 0 Comments


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 VALUES('Afghanistan');
INSERT INTO COUNTRIES VALUES('Albania');
INSERT INTO COUNTRIES VALUES('Algeria');
INSERT INTO COUNTRIES VALUES('American Samoa');
INSERT INTO COUNTRIES VALUES('Andorra');
INSERT INTO COUNTRIES VALUES('Angola');
INSERT INTO COUNTRIES VALUES('Anguilla');
INSERT INTO COUNTRIES VALUES('Antarctica');
INSERT INTO COUNTRIES VALUES('Antigua and Barbuda');
INSERT INTO COUNTRIES VALUES('Argentina');
INSERT INTO COUNTRIES VALUES('Armenia');
INSERT INTO COUNTRIES VALUES('Aruba');
INSERT INTO COUNTRIES VALUES('ustralia');
INSERT INTO COUNTRIES VALUES('Austria');
INSERT INTO COUNTRIES VALUES('Azerbaijan');
INSERT INTO COUNTRIES VALUES('Bahamas');
INSERT INTO COUNTRIES VALUES('Bahrain');
INSERT INTO COUNTRIES VALUES('Bangladesh');
INSERT INTO COUNTRIES VALUES('Barbados');
INSERT INTO COUNTRIES VALUES('Belarus ');
INSERT INTO COUNTRIES VALUES('Belgium ');
INSERT INTO COUNTRIES VALUES('Belize');
INSERT INTO COUNTRIES VALUES('Benin');
INSERT INTO COUNTRIES VALUES('Bermuda');
INSERT INTO COUNTRIES VALUES('Bhutan');
INSERT INTO COUNTRIES VALUES('Bolivia');
INSERT INTO COUNTRIES VALUES('Bosnia and Herzegowina');
INSERT INTO COUNTRIES VALUES('Botswana');
INSERT INTO COUNTRIES VALUES('Bouvet Island');
INSERT INTO COUNTRIES VALUES('Brazil');
INSERT INTO COUNTRIES VALUES('British Indian Ocean');
INSERT INTO COUNTRIES VALUES('Brunei Darussalam');
INSERT INTO COUNTRIES VALUES('Bulgaria');
INSERT INTO COUNTRIES VALUES('Burkina Faso ');
INSERT INTO COUNTRIES VALUES('Burundi');
INSERT INTO COUNTRIES VALUES('Cambodia ');
INSERT INTO COUNTRIES VALUES('Cameroon ');
INSERT INTO COUNTRIES VALUES('anada');
INSERT INTO COUNTRIES VALUES('Cape Verde');
INSERT INTO COUNTRIES VALUES('Cayman Islands');
INSERT INTO COUNTRIES VALUES('Central African Republic');
INSERT INTO COUNTRIES VALUES('Chad');
INSERT INTO COUNTRIES VALUES('Chile');
INSERT INTO COUNTRIES VALUES('China');
INSERT INTO COUNTRIES VALUES('Christmas Island');
INSERT INTO COUNTRIES VALUES('Cocos (Keeling) Islands');
INSERT INTO COUNTRIES VALUES('Colombia');
INSERT INTO COUNTRIES VALUES('Comoros');
INSERT INTO COUNTRIES VALUES('Congo (Democratic Republic of the)');
INSERT INTO COUNTRIES VALUES('Congo (Republic of the)');
INSERT INTO COUNTRIES VALUES('Cook islands');
INSERT INTO COUNTRIES VALUES('Costa Rica');
INSERT INTO COUNTRIES VALUES('Cote dIvoire (Ivory Coast)');
INSERT INTO COUNTRIES VALUES('Croatia');
INSERT INTO COUNTRIES VALUES('Cuba');
INSERT INTO COUNTRIES VALUES('Curaco');
INSERT INTO COUNTRIES VALUES('Cyprus');
INSERT INTO COUNTRIES VALUES('Cyprus (Turkish Republic of Northern)');
INSERT INTO COUNTRIES VALUES('Czech Republic');
INSERT INTO COUNTRIES VALUES('Denmark');
INSERT INTO COUNTRIES VALUES('Djibouti ');
INSERT INTO COUNTRIES VALUES('Dominica');
INSERT INTO COUNTRIES VALUES('Dominican Republic');
INSERT INTO COUNTRIES VALUES('East Timor');
INSERT INTO COUNTRIES VALUES('Ecuador');
INSERT INTO COUNTRIES VALUES('Egypt');
INSERT INTO COUNTRIES VALUES('El Salvador');
INSERT INTO COUNTRIES VALUES('Equatorial Guinea');
INSERT INTO COUNTRIES VALUES('Eritrea');
INSERT INTO COUNTRIES VALUES('Estonia');
INSERT INTO COUNTRIES VALUES('Ethiopia');
INSERT INTO COUNTRIES VALUES('Falkland Islands');
INSERT INTO COUNTRIES VALUES('Faroe Islands');
INSERT INTO COUNTRIES VALUES('Fiji');
INSERT INTO COUNTRIES VALUES('Finland');
INSERT INTO COUNTRIES VALUES('France');
INSERT INTO COUNTRIES VALUES('France, Metropolitan');
INSERT INTO COUNTRIES VALUES('French Guiana ');
INSERT INTO COUNTRIES VALUES('French Polynesia');
INSERT INTO COUNTRIES VALUES('French Southern Territories');
INSERT INTO COUNTRIES VALUES('Gabon');
INSERT INTO COUNTRIES VALUES('Gambia');
INSERT INTO COUNTRIES VALUES('Georgia');
INSERT INTO COUNTRIES VALUES('Germany ');
INSERT INTO COUNTRIES VALUES('Ghana');
INSERT INTO COUNTRIES VALUES('Gibraltar');
INSERT INTO COUNTRIES VALUES('Greece');
INSERT INTO COUNTRIES VALUES('Greenland');
INSERT INTO COUNTRIES VALUES('Grenada');
INSERT INTO COUNTRIES VALUES('Guadeloupe');
INSERT INTO COUNTRIES VALUES('Guam');
INSERT INTO COUNTRIES VALUES('Guatemala');
INSERT INTO COUNTRIES VALUES('Guinea');
INSERT INTO COUNTRIES VALUES('Guinea-Bissau');
INSERT INTO COUNTRIES VALUES('Guyana');
INSERT INTO COUNTRIES VALUES('Haiti');
INSERT INTO COUNTRIES VALUES('Heard and Mc Donald Islands');
INSERT INTO COUNTRIES VALUES('Honduras');
INSERT INTO COUNTRIES VALUES('Hong Kong');
INSERT INTO COUNTRIES VALUES('Hungary');
INSERT INTO COUNTRIES VALUES('Iceland');
INSERT INTO COUNTRIES VALUES('India');
INSERT INTO COUNTRIES VALUES('Indonesia');
INSERT INTO COUNTRIES VALUES('Iran');
INSERT INTO COUNTRIES VALUES('Iraq ');
INSERT INTO COUNTRIES VALUES('Ireland');
INSERT INTO COUNTRIES VALUES('Israel');
INSERT INTO COUNTRIES VALUES('Italy');
INSERT INTO COUNTRIES VALUES('Jamaica');
INSERT INTO COUNTRIES VALUES('Japan');
INSERT INTO COUNTRIES VALUES('Jordan');
INSERT INTO COUNTRIES VALUES('Kazakhstan');
INSERT INTO COUNTRIES VALUES('Kenya');
INSERT INTO COUNTRIES VALUES('Kiribati ');
INSERT INTO COUNTRIES VALUES('Korea, Republic of (south)');
INSERT INTO COUNTRIES VALUES('Kosovo');
INSERT INTO COUNTRIES VALUES('Kuwait');
INSERT INTO COUNTRIES VALUES('Kyrgyzstan');
INSERT INTO COUNTRIES VALUES('Laos (Lao Peoples Democratic Republic)');
INSERT INTO COUNTRIES VALUES('Latvia');
INSERT INTO COUNTRIES VALUES('Lebanon');
INSERT INTO COUNTRIES VALUES('Lesotho');
INSERT INTO COUNTRIES VALUES('Liberia');
INSERT INTO COUNTRIES VALUES('Libyan Arab Jamahiriya');
INSERT INTO COUNTRIES VALUES('Liechtenstein');
INSERT INTO COUNTRIES VALUES('Lithuania');
INSERT INTO COUNTRIES VALUES('Luxembourg');
INSERT INTO COUNTRIES VALUES('Macau');
INSERT INTO COUNTRIES VALUES('Macedonia');
INSERT INTO COUNTRIES VALUES('Madagascar');
INSERT INTO COUNTRIES VALUES('Malawi');
INSERT INTO COUNTRIES VALUES('Malaysia');
INSERT INTO COUNTRIES VALUES('Maldives');
INSERT INTO COUNTRIES VALUES('Mali');
INSERT INTO COUNTRIES VALUES('Malta');
INSERT INTO COUNTRIES VALUES('Marshall Islands');
INSERT INTO COUNTRIES VALUES('Martinique ');
INSERT INTO COUNTRIES VALUES('Mauritania');
INSERT INTO COUNTRIES VALUES('Mauritius');
INSERT INTO COUNTRIES VALUES('Mayotte');
INSERT INTO COUNTRIES VALUES('Mexico');
INSERT INTO COUNTRIES VALUES('Micronesia');
INSERT INTO COUNTRIES VALUES('Moldova');
INSERT INTO COUNTRIES VALUES('Monaco');
INSERT INTO COUNTRIES VALUES('Mongolia');
INSERT INTO COUNTRIES VALUES('Montenegro');
INSERT INTO COUNTRIES VALUES('Montserrat');
INSERT INTO COUNTRIES VALUES('Morocco');
INSERT INTO COUNTRIES VALUES('Mozambique');
INSERT INTO COUNTRIES VALUES('Myanmar');
INSERT INTO COUNTRIES VALUES('Namibia');
INSERT INTO COUNTRIES VALUES('Nauru');
INSERT INTO COUNTRIES VALUES('Nepal');
INSERT INTO COUNTRIES VALUES('Netherlands');
INSERT INTO COUNTRIES VALUES('Netherlands Antilles');
INSERT INTO COUNTRIES VALUES('New Caledonia');
INSERT INTO COUNTRIES VALUES('New Zealand');
INSERT INTO COUNTRIES VALUES('Nicaragua');
INSERT INTO COUNTRIES VALUES('Niger');
INSERT INTO COUNTRIES VALUES('Nigeria');
INSERT INTO COUNTRIES VALUES('Niue');
INSERT INTO COUNTRIES VALUES('Norfolk Island');
INSERT INTO COUNTRIES VALUES('Northern Mariana Islands');
INSERT INTO COUNTRIES VALUES('Norway');
INSERT INTO COUNTRIES VALUES('Oman');
INSERT INTO COUNTRIES VALUES('Pakistan');
INSERT INTO COUNTRIES VALUES('Palau');
INSERT INTO COUNTRIES VALUES('Palestine');
INSERT INTO COUNTRIES VALUES('Panama');
INSERT INTO COUNTRIES VALUES('Papua New Guinea');
INSERT INTO COUNTRIES VALUES('Paraguay ');
INSERT INTO COUNTRIES VALUES('Peru');
INSERT INTO COUNTRIES VALUES('Philippines');
INSERT INTO COUNTRIES VALUES('Pitcairn');
INSERT INTO COUNTRIES VALUES('Poland');
INSERT INTO COUNTRIES VALUES('Portugal');
INSERT INTO COUNTRIES VALUES('Puerto Rico');
INSERT INTO COUNTRIES VALUES('Qatar');
INSERT INTO COUNTRIES VALUES('Reunion');
INSERT INTO COUNTRIES VALUES('Romania');
INSERT INTO COUNTRIES VALUES('Russian Federation');
INSERT INTO COUNTRIES VALUES('Rwanda');
INSERT INTO COUNTRIES VALUES('Saint Helena (UK)');
INSERT INTO COUNTRIES VALUES('Saint Kitts and Nevis');
INSERT INTO COUNTRIES VALUES('Saint Lucia');
INSERT INTO COUNTRIES VALUES('Saint Maarten');
INSERT INTO COUNTRIES VALUES('Saint Pierre and Miquelon (FR)');
INSERT INTO COUNTRIES VALUES('Saint Thomas');
INSERT INTO COUNTRIES VALUES('Saint Vincent and the Grenadines');
INSERT INTO COUNTRIES VALUES('Samoa');
INSERT INTO COUNTRIES VALUES('San Marino');
INSERT INTO COUNTRIES VALUES('Sao Tome and Principe');
INSERT INTO COUNTRIES VALUES('Saudi Arabia');
INSERT INTO COUNTRIES VALUES('Senegal');
INSERT INTO COUNTRIES VALUES('Serbia');
INSERT INTO COUNTRIES VALUES('Serbia + Montenegro (old)');
INSERT INTO COUNTRIES VALUES('Seychelles');
INSERT INTO COUNTRIES VALUES('Sierra Leone');
INSERT INTO COUNTRIES VALUES('Singapore');
INSERT INTO COUNTRIES VALUES('Slovakia');
INSERT INTO COUNTRIES VALUES('Slovenia');
INSERT INTO COUNTRIES VALUES('Solomon Islands');
INSERT INTO COUNTRIES VALUES('Somalia');
INSERT INTO COUNTRIES VALUES('South Africa');
INSERT INTO COUNTRIES VALUES('South Georgia and the South Sandwich Islands');
INSERT INTO COUNTRIES VALUES('Spain');
INSERT INTO COUNTRIES VALUES('Sri Lanka');
INSERT INTO COUNTRIES VALUES('Sudan');
INSERT INTO COUNTRIES VALUES('Suricountry');
INSERT INTO COUNTRIES VALUES('Svalbard and Jan Mayen Islands');
INSERT INTO COUNTRIES VALUES('Swaziland');
INSERT INTO COUNTRIES VALUES('Sweden');
INSERT INTO COUNTRIES VALUES('Switzerland');
INSERT INTO COUNTRIES VALUES('Syrian Arab Republic');
INSERT INTO COUNTRIES VALUES('Taiwan');
INSERT INTO COUNTRIES VALUES('Tajikistan');
INSERT INTO COUNTRIES VALUES('Tanzania');
INSERT INTO COUNTRIES VALUES('Thailand');
INSERT INTO COUNTRIES VALUES('Timor-Leste');
INSERT INTO COUNTRIES VALUES('Togo');
INSERT INTO COUNTRIES VALUES('Tokelau');
INSERT INTO COUNTRIES VALUES('Tonga');
INSERT INTO COUNTRIES VALUES('Trinidad and Tobago');
INSERT INTO COUNTRIES VALUES('Tunisia');
INSERT INTO COUNTRIES VALUES('Turkey');
INSERT INTO COUNTRIES VALUES('Turkmenistan');
INSERT INTO COUNTRIES VALUES('Turks and Caicos Islands');
INSERT INTO COUNTRIES VALUES('Tuvalu');
INSERT INTO COUNTRIES VALUES('Uganda');
INSERT INTO COUNTRIES VALUES('Ukraine');
INSERT INTO COUNTRIES VALUES('United Arab Emirates');
INSERT INTO COUNTRIES VALUES('United Kingdom');
INSERT INTO COUNTRIES VALUES('United States of America');
INSERT INTO COUNTRIES VALUES('Uruguay');
INSERT INTO COUNTRIES VALUES('Uzbekistan');
INSERT INTO COUNTRIES VALUES('Vanuatu');
INSERT INTO COUNTRIES VALUES('Vatican City State');
INSERT INTO COUNTRIES VALUES('Venezuela');
INSERT INTO COUNTRIES VALUES('Vietnam');
INSERT INTO COUNTRIES VALUES('Virgin Islands (British)');
INSERT INTO COUNTRIES VALUES('Virgin Islands (U.S.)');
INSERT INTO COUNTRIES VALUES('Wallis and Futuna Islands');
INSERT INTO COUNTRIES VALUES('Western Sahara');
INSERT INTO COUNTRIES VALUES('Yemen');
INSERT INTO COUNTRIES VALUES('Zaire');
INSERT INTO COUNTRIES VALUES('Zambia');
INSERT INTO COUNTRIES VALUES('Zimbabwe');

Unknown

0 comments:

Subscribe to: Post Comments (Atom)