@manhnguyenv

Welcome to my blog!

Country

November 30, 2017 22:37

Table of Language Culture Names, Codes, and ISO 

https://msdn.microsoft.com/en-us/library/ee825488(v=cs.20).aspx

  1. Language code (E.g. en, fr, de)
  2. Country code (E.g. US, NZ)

.NET Framework Cultures with Date and Time String Formats

http://www.basicdatepicker.com/samples/cultureinfo.aspx

Culture Country codes

http://azuliadesigns.com/list-net-culture-country-codes/

 

[vi-VN] tiếng Việt
[en-US] tiếng Anh - Mỹ
[en-GB] tiếng Anh - Anh
[en-SG] tiếng Anh - Singapore
[en-PH] tiếng Anh - Philippines
[en-MY] tiếng Anh - Malaysia
[zh-CN] tiếng Trung - Trung Quốc
[zh-SG] tiếng Trung - Singapore
[zh-HK] tiếng Trung - Hồng Kông
[zh-MO] tiếng Trung - Ma Cao
[zh-TW] tiếng Trung - Đài Loan
[zh-CA] tiếng Trung - Canada
[zh-US] tiếng Trung - USA
[ja-JP] tiếng Nhật
[ko-KR] tiếng Hàn
[km-KH] tiếng Campuchia
[lo-LA] tiếng Lào
[th-TH] tiếng Thái
[id-ID] tiếng Indonesia
[fil-PH] tiếng Philippines
[ms-MY] tiếng Malaysia
[my-MM] tiếng Myanmar

Generate culture & language codes

class Program
{
    static void Main(string[] args)
    {
        GenerateLanguageInfo();
    }
    public static void GenerateLanguageInfo()
    {
        List<string> list = new List<string>();
        CultureInfo[] cultures = CultureInfo.GetCultures(CultureTypes.SpecificCultures);
        foreach (CultureInfo culture in cultures)
        {
            RegionInfo region = new RegionInfo(culture.LCID);
            var text = string.Format("\"{0} - {1}\", \"{2}-{3}\"",
            region.EnglishName, culture.Parent.EnglishName,
            culture.Parent.TwoLetterISOLanguageName,
            region.TwoLetterISORegionName);
            list.Add(text);
        }
        list.Sort();
        list.ForEach(Console.WriteLine);
    }
}

Country list

https://datahub.io/core/country-list

SQL Server Script 

CREATE TABLE [dbo].[Country](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NULL,
[Code] [varchar](5) NULL,
CONSTRAINT [PK_Country] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Afghanistan','AF');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Åland Islands','AX');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Albania','AL');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Algeria','DZ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'American Samoa','AS');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Andorra','AD');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Angola','AO');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Anguilla','AI');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Antarctica','AQ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Antigua and Barbuda','AG');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Argentina','AR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Armenia','AM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Aruba','AW');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Australia','AU');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Austria','AT');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Azerbaijan','AZ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Bahamas','BS');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Bahrain','BH');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Bangladesh','BD');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Barbados','BB');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Belarus','BY');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Belgium','BE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Belize','BZ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Benin','BJ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Bermuda','BM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Bhutan','BT');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Bolivia, Plurinational State of','BO');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Bonaire, Sint Eustatius and Saba','BQ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Bosnia and Herzegovina','BA');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Botswana','BW');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Bouvet Island','BV');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Brazil','BR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'British Indian Ocean Territory','IO');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Brunei Darussalam','BN');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Bulgaria','BG');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Burkina Faso','BF');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Burundi','BI');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Cambodia','KH');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Cameroon','CM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Canada','CA');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Cape Verde','CV');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Cayman Islands','KY');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Central African Republic','CF');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Chad','TD');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Chile','CL');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'China','CN');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Christmas Island','CX');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Cocos (Keeling) Islands','CC');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Colombia','CO');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Comoros','KM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Congo','CG');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Congo, the Democratic Republic of the','CD');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Cook Islands','CK');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Costa Rica','CR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Côte d’Ivoire','CI');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Croatia','HR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Cuba','CU');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Curaçao','CW');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Cyprus','CY');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Czech Republic','CZ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Denmark','DK');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Djibouti','DJ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Dominica','DM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Dominican Republic','DO');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Ecuador','EC');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Egypt','EG');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'El Salvador','SV');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Equatorial Guinea','GQ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Eritrea','ER');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Estonia','EE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Ethiopia','ET');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Falkland Islands (Malvinas)','FK');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Faroe Islands','FO');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Fiji','FJ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Finland','FI');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'France','FR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'French Guiana','GF');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'French Polynesia','PF');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'French Southern Territories','TF');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Gabon','GA');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Gambia','GM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Georgia','GE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Germany','DE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Ghana','GH');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Gibraltar','GI');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Greece','GR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Greenland','GL');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Grenada','GD');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Guadeloupe','GP');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Guam','GU');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Guatemala','GT');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Guernsey','GG');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Guinea','GN');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Guinea-Bissau','GW');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Guyana','GY');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Haiti','HT');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Heard Island and McDonald Islands','HM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Holy See (Vatican City State)','VA');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Honduras','HN');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Hong Kong','HK');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Hungary','HU');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Iceland','IS');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'India','IN');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Indonesia','ID');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Iran, Islamic Republic of','IR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Iraq','IQ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Ireland','IE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Isle of Man','IM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Israel','IL');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Italy','IT');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Jamaica','JM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Japan','JP');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Jersey','JE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Jordan','JO');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Kazakhstan','KZ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Kenya','KE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Kiribati','KI');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Korea, Democratic People''s Republic of','KP');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Korea, Republic of','KR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Kuwait','KW');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Kyrgyzstan','KG');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Lao People''s Democratic Republic','LA');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Latvia','LV');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Lebanon','LB');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Lesotho','LS');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Liberia','LR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Libya','LY');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Liechtenstein','LI');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Lithuania','LT');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Luxembourg','LU');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Macao','MO');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Macedonia, the Former Yugoslav Republic of','MK');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Madagascar','MG');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Malawi','MW');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Malaysia','MY');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Maldives','MV');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Mali','ML');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Malta','MT');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Marshall Islands','MH');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Martinique','MQ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Mauritania','MR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Mauritius','MU');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Mayotte','YT');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Mexico','MX');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Micronesia, Federated States of','FM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Moldova, Republic of','MD');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Monaco','MC');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Mongolia','MN');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Montenegro','ME');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Montserrat','MS');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Morocco','MA');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Mozambique','MZ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Myanmar','MM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Namibia','NA');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Nauru','NR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Nepal','NP');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Netherlands','NL');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'New Caledonia','NC');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'New Zealand','NZ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Nicaragua','NI');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Niger','NE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Nigeria','NG');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Niue','NU');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Norfolk Island','NF');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Northern Mariana Islands','MP');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Norway','NO');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Oman','OM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Pakistan','PK');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Palau','PW');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Palestine, State of','PS');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Panama','PA');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Papua New Guinea','PG');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Paraguay','PY');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Peru','PE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Philippines','PH');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Pitcairn','PN');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Poland','PL');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Portugal','PT');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Puerto Rico','PR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Qatar','QA');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Réunion','RE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Romania','RO');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Russian Federation','RU');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Rwanda','RW');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Saint Barthélemy','BL');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Saint Helena, Ascension and Tristan da Cunha','SH');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Saint Kitts and Nevis','KN');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Saint Lucia','LC');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Saint Martin (French part)','MF');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Saint Pierre and Miquelon','PM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Saint Vincent and the Grenadines','VC');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Samoa','WS');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'San Marino','SM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Sao Tome and Principe','ST');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Saudi Arabia','SA');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Senegal','SN');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Serbia','RS');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Seychelles','SC');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Sierra Leone','SL');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Singapore','SG');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Sint Maarten (Dutch part)','SX');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Slovakia','SK');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Slovenia','SI');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Solomon Islands','SB');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Somalia','SO');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'South Africa','ZA');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'South Georgia and the South Sandwich Islands','GS');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'South Sudan','SS');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Spain','ES');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Sri Lanka','LK');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Sudan','SD');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Suriname','SR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Svalbard and Jan Mayen','SJ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Swaziland','SZ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Sweden','SE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Switzerland','CH');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Syrian Arab Republic','SY');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Taiwan, Province of China','TW');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Tajikistan','TJ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Tanzania, United Republic of','TZ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Thailand','TH');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Timor-Leste','TL');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Togo','TG');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Tokelau','TK');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Tonga','TO');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Trinidad and Tobago','TT');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Tunisia','TN');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Turkey','TR');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Turkmenistan','TM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Turks and Caicos Islands','TC');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Tuvalu','TV');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Uganda','UG');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Ukraine','UA');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'United Arab Emirates','AE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'United Kingdom','GB');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'United States','US');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'United States Minor Outlying Islands','UM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Uruguay','UY');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Uzbekistan','UZ');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Vanuatu','VU');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Venezuela, Bolivarian Republic of','VE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Viet Nam','VN');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Virgin Islands, British','VG');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Virgin Islands, U.S.','VI');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Wallis and Futuna','WF');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Western Sahara','EH');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Yemen','YE');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Zambia','ZM');
INSERT INTO [dbo].[Country]([Name],[Code]) VALUES(N'Zimbabwe','ZW');

Categories

Recent posts