How to Insert all countries names with their values into DB

I Think you are looking for...

CREATE TABLE dbo.Countries
(
ID int primary key identity(1,1),
Name varchar(50)
);
INSERT INTO Countries (Name) VALUES('Afghanistan');
INSERT INTO Countries (Name) VALUES('Albania');
INSERT INTO Countries (Name) VALUES('Algeria');
INSERT INTO Countries (Name) VALUES('Andorra');
INSERT INTO Countries (Name) VALUES('Angola');
INSERT INTO Countries (Name) VALUES('Anguilla');
INSERT INTO Countries (Name) VALUES('Antigua & Barbuda');
INSERT INTO Countries (Name) VALUES('Argentina');
INSERT INTO Countries (Name) VALUES('Armenia');
INSERT INTO Countries (Name) VALUES('Australia');
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 & Herzegovina');
INSERT INTO Countries (Name) VALUES('Botswana');
INSERT INTO Countries (Name) VALUES('Brazil');
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('Myanmar/Burma');
INSERT INTO Countries (Name) VALUES('Burundi');
INSERT INTO Countries (Name) VALUES('Cambodia');
INSERT INTO Countries (Name) VALUES('Cameroon');
INSERT INTO Countries (Name) VALUES('Canada');
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('Colombia');
INSERT INTO Countries (Name) VALUES('Comoros');
INSERT INTO Countries (Name) VALUES('Congo');
INSERT INTO Countries (Name) VALUES('Costa Rica');
INSERT INTO Countries (Name) VALUES('Croatia');
INSERT INTO Countries (Name) VALUES('Cuba');
INSERT INTO Countries (Name) VALUES('Cyprus');
INSERT INTO Countries (Name) VALUES('Czech Republic');
INSERT INTO Countries (Name) VALUES('Democratic Republic of the Congo');
INSERT INTO Countries (Name) VALUES('Denmark');
INSERT INTO Countries (Name) VALUES('Djibouti');
INSERT INTO Countries (Name) VALUES('Dominican Republic');
INSERT INTO Countries (Name) VALUES('Dominica');
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('Fiji');
INSERT INTO Countries (Name) VALUES('Finland');
INSERT INTO Countries (Name) VALUES('France');
INSERT INTO Countries (Name) VALUES('French Guiana');
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('Great Britain');
INSERT INTO Countries (Name) VALUES('Greece');
INSERT INTO Countries (Name) VALUES('Grenada');
INSERT INTO Countries (Name) VALUES('Guadeloupe');
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('Honduras');
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('Israel and the Occupied Territories');
INSERT INTO Countries (Name) VALUES('Italy');
INSERT INTO Countries (Name) VALUES('Ivory Coast (Cote d''Ivoire)');
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('Kosovo');
INSERT INTO Countries (Name) VALUES('Kuwait');
INSERT INTO Countries (Name) VALUES('Kyrgyz Republic (Kyrgyzstan)');
INSERT INTO Countries (Name) VALUES('Laos');
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('Libya');
INSERT INTO Countries (Name) VALUES('Liechtenstein');
INSERT INTO Countries (Name) VALUES('Lithuania');
INSERT INTO Countries (Name) VALUES('Luxembourg');
INSERT INTO Countries (Name) VALUES('Republic of 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('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('Moldova, Republic of');
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('Namibia');
INSERT INTO Countries (Name) VALUES('Nepal');
INSERT INTO Countries (Name) VALUES('Netherlands');
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('Korea, Democratic Republic of (North Korea)');
INSERT INTO Countries (Name) VALUES('Norway');
INSERT INTO Countries (Name) VALUES('Oman');
INSERT INTO Countries (Name) VALUES('Pacific Islands');
INSERT INTO Countries (Name) VALUES('Pakistan');
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('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 Kitts and Nevis');
INSERT INTO Countries (Name) VALUES('Saint Lucia');
INSERT INTO Countries (Name) VALUES('Saint Vincent''s & Grenadines');
INSERT INTO Countries (Name) VALUES('Samoa');
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('Seychelles');
INSERT INTO Countries (Name) VALUES('Sierra Leone');
INSERT INTO Countries (Name) VALUES('Singapore');
INSERT INTO Countries (Name) VALUES('Slovak Republic (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('Korea, Republic of (South Korea)');
INSERT INTO Countries (Name) VALUES('South Sudan');
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('Swaziland');
INSERT INTO Countries (Name) VALUES('Sweden');
INSERT INTO Countries (Name) VALUES('Switzerland');
INSERT INTO Countries (Name) VALUES('Syria');
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('Trinidad & 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 & Caicos Islands');
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 States of America (USA)');
INSERT INTO Countries (Name) VALUES('Uruguay');
INSERT INTO Countries (Name) VALUES('Uzbekistan');
INSERT INTO Countries (Name) VALUES('Venezuela');
INSERT INTO Countries (Name) VALUES('Vietnam');
INSERT INTO Countries (Name) VALUES('Virgin Islands (UK)');
INSERT INTO Countries (Name) VALUES('Virgin Islands (US)');
INSERT INTO Countries (Name) VALUES('Yemen');
INSERT INTO Countries (Name) VALUES('Zambia');
INSERT INTO Countries (Name) VALUES('Zimbabwe');

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bharathi Raja8y ago
http://www.worldcitiesdatabase.com/world-cities.aspx
-1
Dharmraj Thakur8y ago
I Think you are looking for...
CREATE TABLE dbo.Countries
(
    ID int primary key identity(1,1),
    Name varchar(50)
);

INSERT INTO Countries (Name) VALUES('Afghanistan');
INSERT INTO Countries (Name) VALUES('Albania');
INSERT INTO Countries (Name) VALUES('Algeria');
INSERT INTO Countries (Name) VALUES('Andorra');
INSERT INTO Countries (Name) VALUES('Angola');
INSERT INTO Countries (Name) VALUES('Anguilla');
INSERT INTO Countries (Name) VALUES('Antigua & Barbuda');
INSERT INTO Countries (Name) VALUES('Argentina');
INSERT INTO Countries (Name) VALUES('Armenia');
INSERT INTO Countries (Name) VALUES('Australia');
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 & Herzegovina');
INSERT INTO Countries (Name) VALUES('Botswana');
INSERT INTO Countries (Name) VALUES('Brazil');
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('Myanmar/Burma');
INSERT INTO Countries (Name) VALUES('Burundi');
INSERT INTO Countries (Name) VALUES('Cambodia');
INSERT INTO Countries (Name) VALUES('Cameroon');
INSERT INTO Countries (Name) VALUES('Canada');
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('Colombia');
INSERT INTO Countries (Name) VALUES('Comoros');
INSERT INTO Countries (Name) VALUES('Congo');
INSERT INTO Countries (Name) VALUES('Costa Rica');
INSERT INTO Countries (Name) VALUES('Croatia');
INSERT INTO Countries (Name) VALUES('Cuba');
INSERT INTO Countries (Name) VALUES('Cyprus');
INSERT INTO Countries (Name) VALUES('Czech Republic');
INSERT INTO Countries (Name) VALUES('Democratic Republic of the Congo');
INSERT INTO Countries (Name) VALUES('Denmark');
INSERT INTO Countries (Name) VALUES('Djibouti');
INSERT INTO Countries (Name) VALUES('Dominican Republic');
INSERT INTO Countries (Name) VALUES('Dominica');
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('Fiji');
INSERT INTO Countries (Name) VALUES('Finland');
INSERT INTO Countries (Name) VALUES('France');
INSERT INTO Countries (Name) VALUES('French Guiana');
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('Great Britain');
INSERT INTO Countries (Name) VALUES('Greece');
INSERT INTO Countries (Name) VALUES('Grenada');
INSERT INTO Countries (Name) VALUES('Guadeloupe');
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('Honduras');
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('Israel and the Occupied Territories');
INSERT INTO Countries (Name) VALUES('Italy');
INSERT INTO Countries (Name) VALUES('Ivory Coast (Cote d''Ivoire)');
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('Kosovo');
INSERT INTO Countries (Name) VALUES('Kuwait');
INSERT INTO Countries (Name) VALUES('Kyrgyz Republic (Kyrgyzstan)');
INSERT INTO Countries (Name) VALUES('Laos');
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('Libya');
INSERT INTO Countries (Name) VALUES('Liechtenstein');
INSERT INTO Countries (Name) VALUES('Lithuania');
INSERT INTO Countries (Name) VALUES('Luxembourg');
INSERT INTO Countries (Name) VALUES('Republic of 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('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('Moldova, Republic of');
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('Namibia');
INSERT INTO Countries (Name) VALUES('Nepal');
INSERT INTO Countries (Name) VALUES('Netherlands');
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('Korea, Democratic Republic of (North Korea)');
INSERT INTO Countries (Name) VALUES('Norway');
INSERT INTO Countries (Name) VALUES('Oman');
INSERT INTO Countries (Name) VALUES('Pacific Islands');
INSERT INTO Countries (Name) VALUES('Pakistan');
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('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 Kitts and Nevis');
INSERT INTO Countries (Name) VALUES('Saint Lucia');
INSERT INTO Countries (Name) VALUES('Saint Vincent''s & Grenadines');
INSERT INTO Countries (Name) VALUES('Samoa');
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('Seychelles');
INSERT INTO Countries (Name) VALUES('Sierra Leone');
INSERT INTO Countries (Name) VALUES('Singapore');
INSERT INTO Countries (Name) VALUES('Slovak Republic (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('Korea, Republic of (South Korea)');
INSERT INTO Countries (Name) VALUES('South Sudan');
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('Swaziland');
INSERT INTO Countries (Name) VALUES('Sweden');
INSERT INTO Countries (Name) VALUES('Switzerland');
INSERT INTO Countries (Name) VALUES('Syria');
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('Trinidad & 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 & Caicos Islands');
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 States of America (USA)');
INSERT INTO Countries (Name) VALUES('Uruguay');
INSERT INTO Countries (Name) VALUES('Uzbekistan');
INSERT INTO Countries (Name) VALUES('Venezuela');
INSERT INTO Countries (Name) VALUES('Vietnam');
INSERT INTO Countries (Name) VALUES('Virgin Islands (UK)');
INSERT INTO Countries (Name) VALUES('Virgin Islands (US)');
INSERT INTO Countries (Name) VALUES('Yemen');
INSERT INTO Countries (Name) VALUES('Zambia');
INSERT INTO Countries (Name) VALUES('Zimbabwe');
0
Laxmidhar Sahoo8y ago
sir the list is in which format ?
In Which database u want to insert?
0
Nitin Sontakke8y ago
Hello @Abdalmajeed

Can you please post the line here which will insert a single record in you db?

In my Excel I had already provided part of the SQL.
0
Ajeesh8y ago
You can use the SQL Sever Import Wizard to Import data from Excel
0
Abdulmajeed Alshari8y ago
I am Use SQL Server DB Now How to import the excel file into My DB
0
Ramesh Palanivel8y ago
Hi,

Please upload it from Excel or Access. To download country details, please refer the below Link,
http://www.statvision.com/webinars/countries%20of%20the%20world.xls
0
Nitin Sontakke8y ago
You can even go to https://en.wikipedia.org/wiki/ISO_3166-1

The select the table you want to copy and paste it in MS-Excel and prepare the script with the help of a simple formula. See Excel attached with my previous post.
0
Nitin Sontakke8y ago
See the attached, imported from http://www.nationsonline.org/oneworld/country_code_list.htm

Open Microsoft Excel, click on Data and then 'From Web'. A window opens, paste the link there and press 'Go'. A web-page appears in the window. Click an yellow arrow next to a table you want to import and click OK.
0
Nitin Sontakke8y ago
Which database you have? SQL Server, Oracle, etc. and it's version?
0