Create country table and insert all the countries script for SQL Server

INSERT INTO [country]([countryName],[countryCode])VALUES('AFGHANISTAN','AF');
INSERT INTO [country]([countryName],[countryCode])VALUES('ALAND ISLANDS','AX');
INSERT INTO [country]([countryName],[countryCode])VALUES('ALBANIA','AL');
INSERT INTO [country]([countryName],[countryCode])VALUES('ALGERIA','DZ');
INSERT INTO [country]([countryName],[countryCode])VALUES('AMERICAN SAMOA','AS');
INSERT INTO [country]([countryName],[countryCode])VALUES('ANDORRA','AD');
INSERT INTO [country]([countryName],[countryCode])VALUES('ANGOLA','AO');
INSERT INTO [country]([countryName],[countryCode])VALUES('ANGUILLA','AI');
INSERT INTO [country]([countryName],[countryCode])VALUES('ANTARCTICA','AQ');
INSERT INTO [country]([countryName],[countryCode])VALUES('ANTIGUA AND BARBUDA','AG');
INSERT INTO [country]([countryName],[countryCode])VALUES('ARGENTINA','AR');
INSERT INTO [country]([countryName],[countryCode])VALUES('ARMENIA','AM');
INSERT INTO [country]([countryName],[countryCode])VALUES('ARUBA','AW');
INSERT INTO [country]([countryName],[countryCode])VALUES('AUSTRALIA','AU');
INSERT INTO [country]([countryName],[countryCode])VALUES('AUSTRIA','AT');
INSERT INTO [country]([countryName],[countryCode])VALUES('AZERBAIJAN','AZ');
INSERT INTO [country]([countryName],[countryCode])VALUES('BAHAMAS','BS');
INSERT INTO [country]([countryName],[countryCode])VALUES('BAHRAIN','BH');
INSERT INTO [country]([countryName],[countryCode])VALUES('BANGLADESH','BD');
INSERT INTO [country]([countryName],[countryCode])VALUES('BARBADOS','BB');
INSERT INTO [country]([countryName],[countryCode])VALUES('BELARUS','BY');
INSERT INTO [country]([countryName],[countryCode])VALUES('BELGIUM','BE');
INSERT INTO [country]([countryName],[countryCode])VALUES('BELIZE','BZ');
INSERT INTO [country]([countryName],[countryCode])VALUES('BENIN','BJ');
INSERT INTO [country]([countryName],[countryCode])VALUES('BERMUDA','BM');
INSERT INTO [country]([countryName],[countryCode])VALUES('BHUTAN','BT');
INSERT INTO [country]([countryName],[countryCode])VALUES('BOLIVIA','BO');
INSERT INTO [country]([countryName],[countryCode])VALUES('BONAIRE','BQ');
INSERT INTO [country]([countryName],[countryCode])VALUES('BOSNIA AND HERZEGOVINA','BA');
INSERT INTO [country]([countryName],[countryCode])VALUES('BOTSWANA','BW');
INSERT INTO [country]([countryName],[countryCode])VALUES('BOUVET ISLAND','BV');
INSERT INTO [country]([countryName],[countryCode])VALUES('BRAZIL','BR');
INSERT INTO [country]([countryName],[countryCode])VALUES('BRITISH INDIAN OCEAN TERRITORY','IO');
INSERT INTO [country]([countryName],[countryCode])VALUES('BRUNEI DARUSSALAM','BN');
INSERT INTO [country]([countryName],[countryCode])VALUES('BULGARIA','BG');
INSERT INTO [country]([countryName],[countryCode])VALUES('BURKINA FASO','BF');
INSERT INTO [country]([countryName],[countryCode])VALUES('BURUNDI','BI');
INSERT INTO [country]([countryName],[countryCode])VALUES('CAMBODIA','KH');
INSERT INTO [country]([countryName],[countryCode])VALUES('CAMEROON','CM');
INSERT INTO [country]([countryName],[countryCode])VALUES('CANADA','CA');
INSERT INTO [country]([countryName],[countryCode])VALUES('CAPE VERDE','CV');
INSERT INTO [country]([countryName],[countryCode])VALUES('CAYMAN ISLANDS','KY');
INSERT INTO [country]([countryName],[countryCode])VALUES('CENTRAL AFRICAN REPUBLIC','CF');
INSERT INTO [country]([countryName],[countryCode])VALUES('CHAD','TD');
INSERT INTO [country]([countryName],[countryCode])VALUES('CHILE','CL');
INSERT INTO [country]([countryName],[countryCode])VALUES('CHINA','CN');
INSERT INTO [country]([countryName],[countryCode])VALUES('CHRISTMAS ISLAND','CX');
INSERT INTO [country]([countryName],[countryCode])VALUES('COCOS (KEELING) ISLANDS','CC');
INSERT INTO [country]([countryName],[countryCode])VALUES('COLOMBIA','CO');
INSERT INTO [country]([countryName],[countryCode])VALUES('COMOROS','KM');
INSERT INTO [country]([countryName],[countryCode])VALUES('CONGO','CG');
INSERT INTO [country]([countryName],[countryCode])VALUES('CONGO','CD');
INSERT INTO [country]([countryName],[countryCode])VALUES('COOK ISLANDS','CK');
INSERT INTO [country]([countryName],[countryCode])VALUES('COSTA RICA','CR');
INSERT INTO [country]([countryName],[countryCode])VALUES('Cote dIvoire','CI');
INSERT INTO [country]([countryName],[countryCode])VALUES('CROATIA','HR');
INSERT INTO [country]([countryName],[countryCode])VALUES('CUBA','CU');
INSERT INTO [country]([countryName],[countryCode])VALUES('CURAÇAO','CW');
INSERT INTO [country]([countryName],[countryCode])VALUES('CYPRUS','CY');
INSERT INTO [country]([countryName],[countryCode])VALUES('CZECH REPUBLIC','CZ');
INSERT INTO [country]([countryName],[countryCode])VALUES('DENMARK','DK');
INSERT INTO [country]([countryName],[countryCode])VALUES('DJIBOUTI','DJ');
INSERT INTO [country]([countryName],[countryCode])VALUES('DOMINICA','DM');
INSERT INTO [country]([countryName],[countryCode])VALUES('DOMINICAN REPUBLIC','DO');
INSERT INTO [country]([countryName],[countryCode])VALUES('ECUADOR','EC');
INSERT INTO [country]([countryName],[countryCode])VALUES('EGYPT','EG');
INSERT INTO [country]([countryName],[countryCode])VALUES('EL SALVADOR','SV');
INSERT INTO [country]([countryName],[countryCode])VALUES('EQUATORIAL GUINEA','GQ');
INSERT INTO [country]([countryName],[countryCode])VALUES('ERITREA','ER');
INSERT INTO [country]([countryName],[countryCode])VALUES('ESTONIA','EE');
INSERT INTO [country]([countryName],[countryCode])VALUES('ETHIOPIA','ET');
INSERT INTO [country]([countryName],[countryCode])VALUES('FALKLAND ISLANDS (MALVINAS)','FK');
INSERT INTO [country]([countryName],[countryCode])VALUES('FAROE ISLANDS','FO');
INSERT INTO [country]([countryName],[countryCode])VALUES('FIJI','FJ');
INSERT INTO [country]([countryName],[countryCode])VALUES('FINLAND','FI');
INSERT INTO [country]([countryName],[countryCode])VALUES('FRANCE','FR');
INSERT INTO [country]([countryName],[countryCode])VALUES('FRENCH GUIANA','GF');
INSERT INTO [country]([countryName],[countryCode])VALUES('FRENCH POLYNESIA','PF');
INSERT INTO [country]([countryName],[countryCode])VALUES('FRENCH SOUTHERN TERRITORIES','TF');
INSERT INTO [country]([countryName],[countryCode])VALUES('GABON','GA');
INSERT INTO [country]([countryName],[countryCode])VALUES('GAMBIA','GM');
INSERT INTO [country]([countryName],[countryCode])VALUES('GEORGIA','GE');
INSERT INTO [country]([countryName],[countryCode])VALUES('GERMANY','DE');
INSERT INTO [country]([countryName],[countryCode])VALUES('GHANA','GH');
INSERT INTO [country]([countryName],[countryCode])VALUES('GIBRALTAR','GI');
INSERT INTO [country]([countryName],[countryCode])VALUES('GREECE','GR');
INSERT INTO [country]([countryName],[countryCode])VALUES('GREENLAND','GL');
INSERT INTO [country]([countryName],[countryCode])VALUES('GRENADA','GD');
INSERT INTO [country]([countryName],[countryCode])VALUES('GUADELOUPE','GP');
INSERT INTO [country]([countryName],[countryCode])VALUES('GUAM','GU');
INSERT INTO [country]([countryName],[countryCode])VALUES('GUATEMALA','GT');
INSERT INTO [country]([countryName],[countryCode])VALUES('GUERNSEY','GG');
INSERT INTO [country]([countryName],[countryCode])VALUES('GUINEA','GN');
INSERT INTO [country]([countryName],[countryCode])VALUES('GUINEA-BISSAU','GW');
INSERT INTO [country]([countryName],[countryCode])VALUES('GUYANA','GY');
INSERT INTO [country]([countryName],[countryCode])VALUES('HAITI','HT');
INSERT INTO [country]([countryName],[countryCode])VALUES('HEARD AND MCDONALD ISLANDS','HM');
INSERT INTO [country]([countryName],[countryCode])VALUES('HOLY SEE','VA');
INSERT INTO [country]([countryName],[countryCode])VALUES('HONDURAS','HN');
INSERT INTO [country]([countryName],[countryCode])VALUES('HONG KONG','HK');
INSERT INTO [country]([countryName],[countryCode])VALUES('HUNGARY','HU');
INSERT INTO [country]([countryName],[countryCode])VALUES('ICELAND','IS');
INSERT INTO [country]([countryName],[countryCode])VALUES('INDIA','IN');
INSERT INTO [country]([countryName],[countryCode])VALUES('INDONESIA','ID');
INSERT INTO [country]([countryName],[countryCode])VALUES('IRAN','IR');
INSERT INTO [country]([countryName],[countryCode])VALUES('IRAQ','IQ');
INSERT INTO [country]([countryName],[countryCode])VALUES('IRELAND','IE');
INSERT INTO [country]([countryName],[countryCode])VALUES('ISLE OF MAN','IM');
INSERT INTO [country]([countryName],[countryCode])VALUES('ISRAEL','IL');
INSERT INTO [country]([countryName],[countryCode])VALUES('ITALY','IT');
INSERT INTO [country]([countryName],[countryCode])VALUES('JAMAICA','JM');
INSERT INTO [country]([countryName],[countryCode])VALUES('JAPAN','JP');
INSERT INTO [country]([countryName],[countryCode])VALUES('JERSEY','JE');
INSERT INTO [country]([countryName],[countryCode])VALUES('JORDAN','JO');
INSERT INTO [country]([countryName],[countryCode])VALUES('KAZAKHSTAN','KZ');
INSERT INTO [country]([countryName],[countryCode])VALUES('KENYA','KE');
INSERT INTO [country]([countryName],[countryCode])VALUES('KIRIBATI','KI');
INSERT INTO [country]([countryName],[countryCode])VALUES('KOREA','KP');
INSERT INTO [country]([countryName],[countryCode])VALUES('KOREA','KR');
INSERT INTO [country]([countryName],[countryCode])VALUES('KUWAIT','KW');
INSERT INTO [country]([countryName],[countryCode])VALUES('KYRGYZSTAN','KG');
INSERT INTO [country]([countryName],[countryCode])VALUES('LAO PEOPLES DEMOCRATIC REPUBLIC','LA');
INSERT INTO [country]([countryName],[countryCode])VALUES('LATVIA','LV');
INSERT INTO [country]([countryName],[countryCode])VALUES('LEBANON','LB');
INSERT INTO [country]([countryName],[countryCode])VALUES('LESOTHO','LS');
INSERT INTO [country]([countryName],[countryCode])VALUES('LIBERIA','LR');
INSERT INTO [country]([countryName],[countryCode])VALUES('LIBYAN ARAB JAMAHIRIYA','LY');
INSERT INTO [country]([countryName],[countryCode])VALUES('LIECHTENSTEIN','LI');
INSERT INTO [country]([countryName],[countryCode])VALUES('LITHUANIA','LT');
INSERT INTO [country]([countryName],[countryCode])VALUES('LUXEMBOURG','LU');
INSERT INTO [country]([countryName],[countryCode])VALUES('MACAO','MO');
INSERT INTO [country]([countryName],[countryCode])VALUES('MACEDONIA','MK');
INSERT INTO [country]([countryName],[countryCode])VALUES('MADAGASCAR','MG');
INSERT INTO [country]([countryName],[countryCode])VALUES('MALAWI','MW');
INSERT INTO [country]([countryName],[countryCode])VALUES('MALAYSIA','MY');
INSERT INTO [country]([countryName],[countryCode])VALUES('MALDIVES','MV');
INSERT INTO [country]([countryName],[countryCode])VALUES('MALI','ML');
INSERT INTO [country]([countryName],[countryCode])VALUES('MALTA','MT');
INSERT INTO [country]([countryName],[countryCode])VALUES('MARSHALL ISLANDS','MH');
INSERT INTO [country]([countryName],[countryCode])VALUES('MARTINIQUE','MQ');
INSERT INTO [country]([countryName],[countryCode])VALUES('MAURITANIA','MR');
INSERT INTO [country]([countryName],[countryCode])VALUES('MAURITIUS','MU');
INSERT INTO [country]([countryName],[countryCode])VALUES('MAYOTTE','YT');
INSERT INTO [country]([countryName],[countryCode])VALUES('MEXICO','MX');
INSERT INTO [country]([countryName],[countryCode])VALUES('MICRONESIA','FM');
INSERT INTO [country]([countryName],[countryCode])VALUES('MOLDOVA','MD');
INSERT INTO [country]([countryName],[countryCode])VALUES('MONACO','MC');
INSERT INTO [country]([countryName],[countryCode])VALUES('MONGOLIA','MN');
INSERT INTO [country]([countryName],[countryCode])VALUES('MONTENEGRO','ME');
INSERT INTO [country]([countryName],[countryCode])VALUES('MONTSERRAT','MS');
INSERT INTO [country]([countryName],[countryCode])VALUES('MOROCCO','MA');
INSERT INTO [country]([countryName],[countryCode])VALUES('MOZAMBIQUE','MZ');
INSERT INTO [country]([countryName],[countryCode])VALUES('MYANMAR','MM');
INSERT INTO [country]([countryName],[countryCode])VALUES('NAMIBIA','NA');
INSERT INTO [country]([countryName],[countryCode])VALUES('NAURU','NR');
INSERT INTO [country]([countryName],[countryCode])VALUES('NEPAL','NP');
INSERT INTO [country]([countryName],[countryCode])VALUES('NETHERLANDS','NL');
INSERT INTO [country]([countryName],[countryCode])VALUES('NEW CALEDONIA','NC');
INSERT INTO [country]([countryName],[countryCode])VALUES('NEW ZEALAND','NZ');
INSERT INTO [country]([countryName],[countryCode])VALUES('NICARAGUA','NI');
INSERT INTO [country]([countryName],[countryCode])VALUES('NIGER','NE');
INSERT INTO [country]([countryName],[countryCode])VALUES('NIGERIA','NG');
INSERT INTO [country]([countryName],[countryCode])VALUES('NIUE','NU');
INSERT INTO [country]([countryName],[countryCode])VALUES('NORFOLK ISLAND','NF');
INSERT INTO [country]([countryName],[countryCode])VALUES('NORTHERN MARIANA ISLANDS','MP');
INSERT INTO [country]([countryName],[countryCode])VALUES('NORWAY','NO');
INSERT INTO [country]([countryName],[countryCode])VALUES('OMAN','OM');
INSERT INTO [country]([countryName],[countryCode])VALUES('PAKISTAN','PK');
INSERT INTO [country]([countryName],[countryCode])VALUES('PALAU','PW');
INSERT INTO [country]([countryName],[countryCode])VALUES('PALESTINIAN','PS');
INSERT INTO [country]([countryName],[countryCode])VALUES('PANAMA','PA');
INSERT INTO [country]([countryName],[countryCode])VALUES('PAPUA NEW GUINEA','PG');
INSERT INTO [country]([countryName],[countryCode])VALUES('PARAGUAY','PY');
INSERT INTO [country]([countryName],[countryCode])VALUES('PERU','PE');
INSERT INTO [country]([countryName],[countryCode])VALUES('PHILIPPINES','PH');
INSERT INTO [country]([countryName],[countryCode])VALUES('PITCAIRN','PN');
INSERT INTO [country]([countryName],[countryCode])VALUES('POLAND','PL');
INSERT INTO [country]([countryName],[countryCode])VALUES('PORTUGAL','PT');
INSERT INTO [country]([countryName],[countryCode])VALUES('PUERTO RICO','PR');
INSERT INTO [country]([countryName],[countryCode])VALUES('QATAR','QA');
INSERT INTO [country]([countryName],[countryCode])VALUES('RÉUNION','RE');
INSERT INTO [country]([countryName],[countryCode])VALUES('ROMANIA','RO');
INSERT INTO [country]([countryName],[countryCode])VALUES('RUSSIAN FEDERATION','RU');
INSERT INTO [country]([countryName],[countryCode])VALUES('RWANDA','RW');
INSERT INTO [country]([countryName],[countryCode])VALUES('SAINT BARTHÉLEMY','BL');
INSERT INTO [country]([countryName],[countryCode])VALUES('SAINT HELENA','SH');
INSERT INTO [country]([countryName],[countryCode])VALUES('SAINT KITTS AND NEVIS','KN');
INSERT INTO [country]([countryName],[countryCode])VALUES('SAINT LUCIA','LC');
INSERT INTO [country]([countryName],[countryCode])VALUES('SAINT MARTIN (FRENCH PART)','MF');
INSERT INTO [country]([countryName],[countryCode])VALUES('SAINT PIERRE AND MIQUELON','PM');
INSERT INTO [country]([countryName],[countryCode])VALUES('SAINT VINCENT AND THE GRENADINES','VC');
INSERT INTO [country]([countryName],[countryCode])VALUES('SAMOA','WS');
INSERT INTO [country]([countryName],[countryCode])VALUES('SAN MARINO','SM');
INSERT INTO [country]([countryName],[countryCode])VALUES('SAO TOME AND PRINCIPE','ST');
INSERT INTO [country]([countryName],[countryCode])VALUES('SAUDI ARABIA','SA');
INSERT INTO [country]([countryName],[countryCode])VALUES('SENEGAL','SN');
INSERT INTO [country]([countryName],[countryCode])VALUES('SERBIA','RS');
INSERT INTO [country]([countryName],[countryCode])VALUES('SEYCHELLES','SC');
INSERT INTO [country]([countryName],[countryCode])VALUES('SIERRA LEONE','SL');
INSERT INTO [country]([countryName],[countryCode])VALUES('SINGAPORE','SG');
INSERT INTO [country]([countryName],[countryCode])VALUES('SINT MAARTEN (DUTCH PART)','SX');
INSERT INTO [country]([countryName],[countryCode])VALUES('SLOVAKIA','SK');
INSERT INTO [country]([countryName],[countryCode])VALUES('SLOVENIA','SI');
INSERT INTO [country]([countryName],[countryCode])VALUES('SOLOMON ISLANDS','SB');
INSERT INTO [country]([countryName],[countryCode])VALUES('SOMALIA','SO');
INSERT INTO [country]([countryName],[countryCode])VALUES('SOUTH AFRICA','ZA');
INSERT INTO [country]([countryName],[countryCode])VALUES('SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','GS');
INSERT INTO [country]([countryName],[countryCode])VALUES('SPAIN','ES');
INSERT INTO [country]([countryName],[countryCode])VALUES('SRI LANKA','LK');
INSERT INTO [country]([countryName],[countryCode])VALUES('SUDAN','SD');
INSERT INTO [country]([countryName],[countryCode])VALUES('SURINAME','SR');
INSERT INTO [country]([countryName],[countryCode])VALUES('SVALBARD AND JAN MAYEN','SJ');
INSERT INTO [country]([countryName],[countryCode])VALUES('SWAZILAND','SZ');
INSERT INTO [country]([countryName],[countryCode])VALUES('SWEDEN','SE');
INSERT INTO [country]([countryName],[countryCode])VALUES('SWITZERLAND','CH');
INSERT INTO [country]([countryName],[countryCode])VALUES('SYRIAN ARAB REPUBLIC','SY');
INSERT INTO [country]([countryName],[countryCode])VALUES('TAIWAN, PROVINCE OF CHINA','TW');
INSERT INTO [country]([countryName],[countryCode])VALUES('TAJIKISTAN','TJ');
INSERT INTO [country]([countryName],[countryCode])VALUES('TANZANIA, UNITED REPUBLIC OF','TZ');
INSERT INTO [country]([countryName],[countryCode])VALUES('THAILAND','TH');
INSERT INTO [country]([countryName],[countryCode])VALUES('TIMOR-LESTE','TL');
INSERT INTO [country]([countryName],[countryCode])VALUES('TOGO','TG');
INSERT INTO [country]([countryName],[countryCode])VALUES('TOKELAU','TK');
INSERT INTO [country]([countryName],[countryCode])VALUES('TONGA','TO');
INSERT INTO [country]([countryName],[countryCode])VALUES('TRINIDAD AND TOBAGO','TT');
INSERT INTO [country]([countryName],[countryCode])VALUES('TUNISIA','TN');
INSERT INTO [country]([countryName],[countryCode])VALUES('TURKEY','TR');
INSERT INTO [country]([countryName],[countryCode])VALUES('TURKMENISTAN','TM');
INSERT INTO [country]([countryName],[countryCode])VALUES('TURKS AND CAICOS ISLANDS','TC');
INSERT INTO [country]([countryName],[countryCode])VALUES('TUVALU','TV');
INSERT INTO [country]([countryName],[countryCode])VALUES('UGANDA','UG');
INSERT INTO [country]([countryName],[countryCode])VALUES('UKRAINE','UA');
INSERT INTO [country]([countryName],[countryCode])VALUES('UNITED ARAB EMIRATES','AE');
INSERT INTO [country]([countryName],[countryCode])VALUES('UNITED KINGDOM','GB');
INSERT INTO [country]([countryName],[countryCode])VALUES('UNITED STATES','US');
INSERT INTO [country]([countryName],[countryCode])VALUES('UNITED STATES MINOR OUTLYING ISLANDS','UM');
INSERT INTO [country]([countryName],[countryCode])VALUES('URUGUAY','UY');
INSERT INTO [country]([countryName],[countryCode])VALUES('UZBEKISTAN','UZ');
INSERT INTO [country]([countryName],[countryCode])VALUES('VANUATU','VU');
INSERT INTO [country]([countryName],[countryCode])VALUES('VENEZUELA','VE');
INSERT INTO [country]([countryName],[countryCode])VALUES('VIET NAM','VN');
INSERT INTO [country]([countryName],[countryCode])VALUES('VIRGIN ISLANDS, BRITISH','VG');
INSERT INTO [country]([countryName],[countryCode])VALUES('VIRGIN ISLANDS, U.S.','VI');
INSERT INTO [country]([countryName],[countryCode])VALUES('WALLIS AND FUTUNA','WF');
INSERT INTO [country]([countryName],[countryCode])VALUES('WESTERN SAHARA','EH');
INSERT INTO [country]([countryName],[countryCode])VALUES('YEMEN','YE');
INSERT INTO [country]([countryName],[countryCode])VALUES('ZAMBIA','ZM');
INSERT INTO [country]([countryName],[countryCode])VALUES('ZIMBABWE','ZW');

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值