Skip to content

Instantly share code, notes, and snippets.

@ProNotion

ProNotion/ISO3166-Country-List-Table.sq

Created January 21, 2016 12:01
Show Gist options
  • Star 3 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save ProNotion/b97e04b4f2961866298e to your computer and use it in GitHub Desktop.
Save ProNotion/b97e04b4f2961866298e to your computer and use it in GitHub Desktop.
Download ZIP
TSQL ISO3166 Country List Table
Raw
ISO3166-Country-List-Table.sq
PRINT 'Checking for existence of table ''countries'''
/****** Object: Table [dbo].[Countries] Script Date: 11/09/2006 16:58:01 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Countries]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Countries]
PRINT 'Existing table ''countries'' dropped!'
GO
/****** Object: Table [dbo].[Countries] Script Date: 11/09/2006 16:58:01 ******/
PRINT 'Creating table ''countries'''
CREATE TABLE [dbo].[Countries] (
[name] [varchar] (255) COLLATE Latin1_General_CI_AS NOT NULL ,
[alpha2] [char] (2) COLLATE Latin1_General_CI_AS NOT NULL ,
[alpha3] [char] (3) COLLATE Latin1_General_CI_AS NOT NULL ,
[numeric3] [smallint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Countries] ADD
CONSTRAINT [PK_iso3166] PRIMARY KEY CLUSTERED
(
[alpha2]
) ON [PRIMARY]
GO
SET NOCOUNT ON
PRINT 'Inserting values into [Countries]'
/****** Create Insert Statements for countries Script Date: 11/09/2006 16:58:01 ******/
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Andorra','AD','AND',20)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('United Arab Emirates','AE','ARE',784)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Afghanistan','AF','AFG',4)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Antigua and Barbuda','AG','ATG',28)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Anguilla','AI','AIA',660)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Albania','AL','ALB',8)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Armenia','AM','ARM',51)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Netherlands Antilles','AN','ANT',530)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Angola','AO','AGO',24)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Antarctica','AQ','ATA',10)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Argentina','AR','ARG',32)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('American Samoa','AS','ASM',16)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Austria','AT','AUT',40)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Australia','AU','AUS',36)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Aruba','AW','ABW',533)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Åland Islands','AX','ALA',248)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Azerbaijan','AZ','AZE',31)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Bosnia and Herzegovina','BA','BIH',70)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Barbados','BB','BRB',52)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Bangladesh','BD','BGD',50)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Belgium','BE','BEL',56)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Burkina Faso','BF','BFA',854)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Bulgaria','BG','BGR',100)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Bahrain','BH','BHR',48)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Burundi','BI','BDI',108)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Benin','BJ','BEN',204)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Bermuda','BM','BMU',60)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Brunei Darussalam','BN','BRN',96)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Bolivia','BO','BOL',68)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Brazil','BR','BRA',76)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Bahamas','BS','BHS',44)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Bhutan','BT','BTN',64)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Bouvet Island','BV','BVT',74)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Botswana','BW','BWA',72)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Belarus','BY','BLR',112)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Belize','BZ','BLZ',84)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Canada','CA','CAN',124)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Cocos (Keeling) Islands','CC','CCK',166)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Congo, the Democratic Republic of the','CD','COD',180)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Central African Republic','CF','CAF',140)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Congo','CG','COG',178)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Switzerland','CH','CHE',756)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Cote D''Ivoire','CI','CIV',384)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Cook Islands','CK','COK',184)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Chile','CL','CHL',152)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Cameroon','CM','CMR',120)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('China','CN','CHN',156)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Colombia','CO','COL',170)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Costa Rica','CR','CRI',188)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Serbia and Montenegro','CS','SCG',891)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Cuba','CU','CUB',192)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Cape Verde','CV','CPV',132)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Christmas Island','CX','CXR',162)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Cyprus','CY','CYP',196)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Czech Republic','CZ','CZE',203)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Germany','DE','DEU',276)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Djibouti','DJ','DJI',262)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Denmark','DK','DNK',208)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Dominica','DM','DMA',212)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Dominican Republic','DO','DOM',214)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Algeria','DZ','DZA',12)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Ecuador','EC','ECU',218)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Estonia','EE','EST',233)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Egypt','EG','EGY',818)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Western Sahara','EH','ESH',732)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Eritrea','ER','ERI',232)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Spain','ES','ESP',724)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Ethiopia','ET','ETH',231)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Finland','FI','FIN',246)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Fiji','FJ','FJI',242)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Falkland Islands (Malvinas)','FK','FLK',238)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Micronesia, Federated States of','FM','FSM',583)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Faroe Islands','FO','FRO',234)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('France','FR','FRA',250)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Gabon','GA','GAB',266)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('United Kingdom','GB','GBR',826)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Grenada','GD','GRD',308)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Georgia','GE','GEO',268)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('French Guiana','GF','GUF',254)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Ghana','GH','GHA',288)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Gibraltar','GI','GIB',292)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Greenland','GL','GRL',304)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Gambia','GM','GMB',270)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Guinea','GN','GIN',324)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Guadeloupe','GP','GLP',312)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Equatorial Guinea','GQ','GNQ',226)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Greece','GR','GRC',300)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('South Georgia and the South Sandwich Islands','GS','SGS',239)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Guatemala','GT','GTM',320)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Guam','GU','GUM',316)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Guinea-Bissau','GW','GNB',624)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Guyana','GY','GUY',328)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Hong Kong','HK','HKG',344)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Heard Island and Mcdonald Islands','HM','HMD',334)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Honduras','HN','HND',340)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Croatia','HR','HRV',191)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Haiti','HT','HTI',332)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Hungary','HU','HUN',348)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Indonesia','ID','IDN',360)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Ireland','IE','IRL',372)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Israel','IL','ISR',376)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('India','IN','IND',356)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('British Indian Ocean Territory','IO','IOT',86)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Iraq','IQ','IRQ',368)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Iran, Islamic Republic of','IR','IRN',364)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Iceland','IS','ISL',352)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Italy','IT','ITA',380)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Jamaica','JM','JAM',388)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Jordan','JO','JOR',400)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Japan','JP','JPN',392)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Kenya','KE','KEN',404)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Kyrgyzstan','KG','KGZ',417)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Cambodia','KH','KHM',116)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Kiribati','KI','KIR',296)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Comoros','KM','COM',174)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Saint Kitts and Nevis','KN','KNA',659)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Korea, Democratic People''s Republic of','KP','PRK',408)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Korea, Republic of','KR','KOR',410)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Kuwait','KW','KWT',414)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Cayman Islands','KY','CYM',136)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Kazakhstan','KZ','KAZ',398)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Lao People''s Democratic Republic','LA','LAO',418)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Lebanon','LB','LBN',422)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Saint Lucia','LC','LCA',662)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Liechtenstein','LI','LIE',438)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Sri Lanka','LK','LKA',144)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Liberia','LR','LBR',430)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Lesotho','LS','LSO',426)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Lithuania','LT','LTU',440)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Luxembourg','LU','LUX',442)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Latvia','LV','LVA',428)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Libyan Arab Jamahiriya','LY','LBY',434)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Morocco','MA','MAR',504)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Monaco','MC','MCO',492)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Moldova, Republic of','MD','MDA',498)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Madagascar','MG','MDG',450)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Marshall Islands','MH','MHL',584)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Macedonia, the Former Yugoslav Republic of','MK','MKD',807)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Mali','ML','MLI',466)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Myanmar','MM','MMR',104)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Mongolia','MN','MNG',496)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Macao','MO','MAC',446)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Northern Mariana Islands','MP','MNP',580)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Martinique','MQ','MTQ',474)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Mauritania','MR','MRT',478)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Montserrat','MS','MSR',500)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Malta','MT','MLT',470)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Mauritius','MU','MUS',480)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Maldives','MV','MDV',462)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Malawi','MW','MWI',454)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Mexico','MX','MEX',484)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Malaysia','MY','MYS',458)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Mozambique','MZ','MOZ',508)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Namibia','NA','NAM',516)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('New Caledonia','NC','NCL',540)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Niger','NE','NER',562)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Norfolk Island','NF','NFK',574)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Nigeria','NG','NGA',566)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Nicaragua','NI','NIC',558)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Netherlands','NL','NLD',528)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Norway','NO','NOR',578)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Nepal','NP','NPL',524)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Nauru','NR','NRU',520)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Niue','NU','NIU',570)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('New Zealand','NZ','NZL',554)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Oman','OM','OMN',512)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Panama','PA','PAN',591)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Peru','PE','PER',604)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('French Polynesia','PF','PYF',258)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Papua New Guinea','PG','PNG',598)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Philippines','PH','PHL',608)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Pakistan','PK','PAK',586)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Poland','PL','POL',616)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Saint Pierre and Miquelon','PM','SPM',666)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Pitcairn','PN','PCN',612)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Puerto Rico','PR','PRI',630)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Palestinian Territory, Occupied','PS','PSE',275)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Portugal','PT','PRT',620)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Palau','PW','PLW',585)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Paraguay','PY','PRY',600)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Qatar','QA','QAT',634)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Reunion','RE','REU',638)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Romania','RO','ROU',642)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Russian Federation','RU','RUS',643)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Rwanda','RW','RWA',646)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Saudi Arabia','SA','SAU',682)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Solomon Islands','SB','SLB',90)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Seychelles','SC','SYC',690)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Sudan','SD','SDN',736)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Sweden','SE','SWE',752)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Singapore','SG','SGP',702)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Saint Helena','SH','SHN',654)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Slovenia','SI','SVN',705)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Svalbard and Jan Mayen','SJ','SJM',744)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Slovakia','SK','SVK',703)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Sierra Leone','SL','SLE',694)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('San Marino','SM','SMR',674)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Senegal','SN','SEN',686)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Somalia','SO','SOM',706)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Suriname','SR','SUR',740)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Sao Tome and Principe','ST','STP',678)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('El Salvador','SV','SLV',222)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Syrian Arab Republic','SY','SYR',760)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Swaziland','SZ','SWZ',748)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Turks and Caicos Islands','TC','TCA',796)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Chad','TD','TCD',148)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('French Southern Territories','TF','ATF',260)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Togo','TG','TGO',768)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Thailand','TH','THA',764)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Tajikistan','TJ','TJK',762)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Tokelau','TK','TKL',772)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Timor-Leste','TL','TLS',626)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Turkmenistan','TM','TKM',795)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Tunisia','TN','TUN',788)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Tonga','TO','TON',776)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Turkey','TR','TUR',792)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Trinidad and Tobago','TT','TTO',780)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Tuvalu','TV','TUV',798)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('TAIWAN','TW','TWN',158)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Tanzania, United Republic of','TZ','TZA',834)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Ukraine','UA','UKR',804)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Uganda','UG','UGA',800)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('United Kingdom','UK','GBR',826)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('United States Minor Outlying Islands','UM','UMI',581)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('United States','US','USA',840)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Uruguay','UY','URY',858)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Uzbekistan','UZ','UZB',860)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Holy See (Vatican City State)','VA','VAT',336)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Saint Vincent and the Grenadines','VC','VCT',670)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Venezuela','VE','VEN',862)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Virgin Islands, British','VG','VGB',92)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Virgin Islands, U.s.','VI','VIR',850)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Viet Nam','VN','VNM',704)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Vanuatu','VU','VUT',548)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Wallis and Futuna','WF','WLF',876)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Samoa','WS','WSM',882)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Yemen','YE','YEM',887)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Mayotte','YT','MYT',175)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Serbia and Montenegro','YU','SCG',891)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('South Africa','ZA','ZAF',710)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Zambia','ZM','ZMB',894)
INSERT INTO [Countries] ([name],[alpha2],[alpha3],[numeric3])VALUES('Zimbabwe','ZW','ZWE',716)
PRINT 'Done'
SET NOCOUNT OFF
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment