Realized Design: Country Code Dimension or Lookup Table

It's common for a system to need a standardized country table that holds the ISO 3166 country codes and I do not like to start from scratch for each project. Below is the being DDL and DML I use to build out the initial country table. This data is from about 2013, so it might be a bit outdated, but still easily updated if you reference the ISO 3166 Country Codes site, or the Wikipedia ISO 3166 page.

DDL to build the table:

       

use yourdatabase;
go

if exists (select * from sys.objects where object_id = object_id(N'dbo.Country'))
  drop table dbo.Country
  go

 CREATE TABLE dbo.Country
 (
  CountryKey     smallint  IDENTITY (1,1) ,
  CountryA2Code  nvarchar(2)  NOT NULL ,
  CountryA3Code  nvarchar(3)  NULL ,
  CountryNum     nvarchar(10)  NULL ,
  CountryName    nvarchar(100)  NULL ,
  CountryDesc    nvarchar(255)  NULL ,     
  SortOrder      smallint  NOT NULL ,
  AuditKey       int  NOT NULL ,
  CONSTRAINT  PK_Country_CountryKey  PRIMARY KEY (CountryKey  ASC)
 )
 go


  -- AK
  CREATE  UNIQUE INDEX AK_CountryA2 ON dbo.Country ( CountryA2Code  ASC )
  go

  CREATE  UNIQUE INDEX AK_CountryA3 ON dbo.Country ( CountryA3Code  ASC )
  go

  CREATE  UNIQUE INDEX AK_CountryNum ON dbo.Country ( CountryNum  ASC )
  go

  CREATE  UNIQUE INDEX AK_CountryName ON dbo.Country ( CountryName  ASC )
  go

DML to do the initial data population:

       

use yourdatabase;
go


SET QUOTED_IDENTIFIER ON

/* -----------------------------------------
   Country

   ----------------------------------------- */

SET IDENTITY_INSERT dbo.Country  ON

INSERT INTO dbo.Country ( CountryKey, CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES( 0,'-','-',0,'unknown',0,'A',1)
INSERT INTO dbo.Country ( CountryKey, CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES( 1,'AU','AUS',36,'Australia',130,'A',1)
INSERT INTO dbo.Country ( CountryKey, CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES( 2,'US','USA',840,'United States',2230,'A',1)
INSERT INTO dbo.Country ( CountryKey, CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES( 4,'GB','GBR',826,'United Kingdom',2220,'A',1)
INSERT INTO dbo.Country ( CountryKey, CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES( 8,'CA','CAN',124,'Canada',380,'A',1)
INSERT INTO dbo.Country ( CountryKey, CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES( 6,'FI','FIN',246,'Finland',720,'A',1)
INSERT INTO dbo.Country ( CountryKey, CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES( 7,'FR','FRA',250,'France',730,'A',1)
INSERT INTO dbo.Country ( CountryKey, CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES( 5,'IT','ITA',380,'Italy',1050,'A',1)
INSERT INTO dbo.Country ( CountryKey, CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES( 9,'SG','SGP',702,'Singapore',1880,'A',1)

SET IDENTITY_INSERT dbo.Country OFF
go

--- MORE COUNTRIES, WITHOUT FORCING THE ID
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'UM','UMI',581,'United States Minor Outlying Islands',2240,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AF','AFG',4,'Afghanistan',10,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AL','ALB',8,'Albania',20,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'DZ','DZA',12,'Algeria',30,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AS','ASM',16,'American Samoa',40,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AD','AND',20,'Andorra',50,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AO','AGO',24,'Angola',60,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AI','AIA',660,'Anguilla',70,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AQ','ATA',10,'Antarctica',80,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AG','ATG',28,'Antigua and Barbuda',90,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AR','ARG',32,'Argentina',100,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AM','ARM',51,'Armenia',110,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AW','ABW',533,'Aruba',120,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AT','AUT',40,'Austria',140,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AZ','AZE',31,'Azerbaijan',150,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BS','BHS',44,'Bahamas',160,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BH','BHR',48,'Bahrain',170,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BD','BGD',50,'Bangladesh',180,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BB','BRB',52,'Barbados',190,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BY','BLR',112,'Belarus',200,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BE','BEL',56,'Belgium',210,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BZ','BLZ',84,'Belize',220,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BJ','BEN',204,'Benin',230,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BM','BMU',60,'Bermuda',240,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BT','BTN',64,'Bhutan',250,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BO','BOL',68,'Bolivia',260,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BA','BIH',70,'Bosnia and Herzegowina',270,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BW','BWA',72,'Botswana',280,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BV','BVT',74,'Bouvet Island',290,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BR','BRA',76,'Brazil',300,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'IO','IOT',86,'British Indian Ocean Territory',310,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BN','BRN',96,'Brunei Darussalam',320,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BG','BGR',100,'Bulgaria',330,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BF','BFA',854,'Burkina Faso',340,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'BI','BDI',108,'Burundi',350,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'KH','KHM',116,'Cambodia',360,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CM','CMR',120,'Cameroon',370,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CV','CPV',132,'Cape Verde',390,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'KY','CYM',136,'Cayman islands',400,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CF','CAF',140,'Central African Republic',410,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TD','TCD',148,'Chad',420,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CL','CHL',152,'Chile',430,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CN','CHN',156,'China',440,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CX','CXR',162,'Christmas Island',450,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CC','CCK',166,'Cocos (Keeling) Islands',460,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CO','COL',170,'Colombia',470,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'KM','COM',174,'Comoros',480,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CG','COG',178,'Congo',490,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CK','COK',184,'Cook Islands',500,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CR','CRI',188,'Costa Rica',510,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CI','CIV',384,'Cote d‘ivoire',520,'A',1) 
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'HR','HRV',191,'Croatia (local name: Hrvatska)',530,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CU','CUB',192,'Cuba',540,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CY','CYP',196,'Cyprus',550,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CZ','CZE',203,'Czech Republic',560,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'DK','DNK',208,'Denmark',570,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'DJ','DJI',262,'Djibouti',580,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'DM','DMA',212,'Dominica',590,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'DO','DOM',214,'Dominican Republic',600,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TP','TMP',626,'East Timor',610,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'EC','ECU',218,'Ecuador',620,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'EG','EGY',818,'Egypt',630,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SV','SLV',222,'El Salvador',640,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GQ','GNQ',226,'Equatorial Guinea',650,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'ER','ERI',232,'Eritrea',660,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'EE','EST',233,'Estonia',670,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'ET','ETH',231,'Ethiopia',680,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'FK','FLK',238,'Falkland Islands (Malvinas)',690,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'FO','FRO',234,'Faroe Islands',700,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'FJ','FJI',242,'Fiji',710,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'FX','FXX',249,'France, Metropolitan',740,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GF','GUF',254,'French Guiana',750,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'PF','PYF',258,'French Polynesia',760,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TF','ATF',260,'French Southern Territories',770,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GA','GAB',266,'Gabon',780,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GM','GMB',270,'Gambia',790,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GE','GEO',268,'Georgia',800,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'DE','DEU',276,'Germany',810,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GH','GHA',288,'Ghana',820,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GI','GIB',292,'Gibraltar',830,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GR','GRC',300,'Greece',840,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GL','GRL',304,'Greenland',850,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GD','GRD',308,'Grenada',860,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GP','GLP',312,'Guadeloupe',870,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GU','GUM',316,'Guam',880,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GT','GTM',320,'Guatemala',890,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GN','GIN',324,'Guinea',900,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GW','GNB',624,'Guinea-Bissau',910,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GY','GUY',328,'Guyana',920,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'HT','HTI',332,'Haiti',930,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'HM','HMD',334,'Heard and Mc Donald Islands',940,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'HN','HND',340,'Honduras',950,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'HK','HKG',344,'Hong Kong',960,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'HU','HUN',348,'Hungary',970,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'IS','ISL',352,'Iceland',980,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'IN','IND',356,'India',990,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'ID','IDN',360,'Indonesia',1000,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'IR','IRN',364,'Iran (Islamic Republic of)',1010,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'IQ','IRQ',368,'Iraq',1020,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'IE','IRL',372,'Ireland',1030,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'IL','ISR',376,'Israel',1040,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'JM','JAM',388,'Jamaica',1060,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'JP','JPN',392,'Japan',1070,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'JO','JOR',400,'Jordan',1080,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'KZ','KAZ',398,'Kazakhstan',1090,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'KE','KEN',404,'Kenya',1100,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'KI','KIR',296,'Kiribati',1110,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'KP','PRK',408,'Korea (north), Democratic People’s Republic of',1120,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'KR','KOR',410,'Korea (south), Republic of',1130,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'KW','KWT',414,'Kuwait',1140,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'KG','KGZ',417,'Kyrgyzstan',1150,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'LA','LAO',418,'Lao People’s Democratic Republic',1160,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'LV','LVA',428,'Latvia',1170,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'LB','LBN',422,'Lebanon',1180,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'LS','LSO',426,'Lesotho',1190,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'LR','LBR',430,'Liberia',1200,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'LY','LBY',434,'Libyan Arab Jamahiriya',1210,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'LI','LIE',438,'Liechtenstein',1220,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'LT','LTU',440,'Lithuania',1230,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'LU','LUX',442,'Luxembourg',1240,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MO','MAC',446,'Macau',1250,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MK','MKD',807,'Macedonia, the former Yugoslav Republic of',1260,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MG','MDG',450,'Madagascar',1270,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MW','MWI',454,'Malawi',1280,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MY','MYS',458,'Malaysia',1290,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MV','MDV',462,'Maldives',1300,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'ML','MLI',466,'Mali',1310,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MT','MLT',470,'Malta',1320,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MH','MHL',584,'Marshall Islands',1330,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MQ','MTQ',474,'Martinique',1340,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MR','MRT',478,'Mauritania',1350,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MU','MUS',480,'Mauritius',1360,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'YT','MYT',175,'Mayotte',1370,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MX','MEX',484,'Mexico',1380,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'FM','FSM',583,'Micronesia, Federated States of',1390,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MD','MDA',498,'Moldova, Republic of',1400,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MC','MCO',492,'Monaco',1410,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MN','MNG',496,'Mongolia',1420,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MS','MSR',500,'Montserrat',1430,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MA','MAR',504,'Morocco',1440,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MZ','MOZ',508,'Mozambique',1450,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MM','MMR',104,'Myanmar',1460,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'NA','NAM',516,'Namibia',1470,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'NR','NRU',520,'Nauru',1480,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'NP','NPL',524,'Nepal',1490,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'NL','NLD',528,'Netherlands',1500,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AN','ANT',530,'Netherlands Antilles',1510,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'NC','NCL',540,'New Caledonia',1520,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'NZ','NZL',554,'New Zealand',1530,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'NI','NIC',558,'Nicaragua',1540,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'NE','NER',562,'Niger',1550,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'NG','NGA',566,'Nigeria',1560,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'NU','NIU',570,'Niue',1570,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'NF','NFK',574,'Norfolk Island',1580,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'MP','MNP',580,'Northern Mariana Islands',1590,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'NO','NOR',578,'Norway',1600,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'OM','OMN',512,'Oman',1610,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'PK','PAK',586,'Pakistan',1620,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'PW','PLW',585,'Palau',1630,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'PA','PAN',591,'Panama',1640,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'PG','PNG',598,'Papua New Guinea',1650,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'PY','PRY',600,'Paraguay',1660,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'PE','PER',604,'Peru',1670,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'PH','PHL',608,'Philippines',1680,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'PN','PCN',612,'Pitcairn',1690,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'PL','POL',616,'Poland',1700,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'PT','PRT',620,'Portugal',1710,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'PR','PRI',630,'Puerto Rico',1720,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'QA','QAT',634,'Qatar',1730,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'RE','REU',638,'Reunion',1740,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'RO','ROM',642,'Romania',1750,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'RU','RUS',643,'Russian Federation',1760,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'RW','RWA',646,'Rwanda',1770,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'KN','KNA',659,'Saint Kitts and Nevis',1780,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'LC','LCA',662,'Saint Lucia',1790,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'VC','VCT',670,'Saint Vincent and the Grenadines',1800,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'WS','WSM',882,'Samoa',1810,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SM','SMR',674,'San Marino',1820,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'ST','STP',678,'Sao Tome and Principe',1830,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SA','SAU',682,'Saudi Arabia',1840,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SN','SEN',686,'Senegal',1850,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SC','SYC',690,'Seychelles',1860,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SL','SLE',694,'Sierra Leone',1870,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SK','SVK',703,'Slovakia (Slovak Republic)',1890,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SI','SVN',705,'Slovenia',1900,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SB','SLB',90,'Solomon Islands',1910,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SO','SOM',706,'Somalia',1920,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'ZA','ZAF',710,'South Africa',1930,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'GS','SGS',239,'South Georgia and the South Sandwich Islands',1940,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'ES','ESP',724,'Spain',1950,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'LK','LKA',144,'Sri Lanka',1960,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SH','SHN',654,'St. Helena',1970,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'PM','SPM',666,'St. Pierre and Miquelon',1980,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SD','SDN',736,'Sudan',1990,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SR','SUR',740,'Suriname',2000,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SJ','SJM',744,'Svalbard and Jan Mayen Islands',2010,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SZ','SWZ',748,'Swaziland',2020,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SE','SWE',752,'Sweden',2030,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'CH','CHE',756,'Switzerland',2040,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'SY','SYR',760,'Syrian Arab Republic',2050,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TW','TWN',158,'Taiwan',2060,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TJ','TJK',762,'Tajikistan',2070,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TZ','TZA',834,'Tanzania, United Republic of',2080,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TH','THA',764,'Thailand',2090,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TG','TGO',768,'Togo',2100,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TK','TKL',772,'Tokelau',2110,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TO','TON',776,'Tonga',2120,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TT','TTO',780,'Trinidad and Tobago',2130,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TN','TUN',788,'Tunisia',2140,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TR','TUR',792,'Turkey',2150,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TM','TKM',795,'Turkmenistan',2160,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TC','TCA',796,'Turks and Caicos Islands',2170,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'TV','TUV',798,'Tuvalu',2180,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'UG','UGA',800,'Uganda',2190,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'UA','UKR',804,'Ukraine',2200,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'AE','ARE',784,'United Arab Emirates',2210,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'UY','URY',858,'Uruguay',2250,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'UZ','UZB',860,'Uzbekistan',2260,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'VU','VUT',548,'Vanuatu',2270,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'VA','VAT',336,'Vatican City State (Holy See)',2280,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'VE','VEN',862,'Venezuela',2290,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'VN','VNM',704,'Viet Nam',2300,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'VG','VGB',92,'Virgin Islands (British)',2310,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'VI','VIR',850,'Virgin islands (U.S.)',2320,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'WF','WLF',876,'Wallis and Futuna Islands',2330,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'EH','ESH',732,'Western Sahara',2340,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'YE','YEM',887,'Yemen',2350,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'YU','YUG',891,'Yugoslavia',2360,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'ZR','ZAR',180,'Zaire',2370,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'ZM','ZMB',894,'Zambia',2380,'A',1)
INSERT INTO dbo.Country ( CountryA2Code, CountryA3Code, CountryNum, CountryName, SortOrder, CountryDesc, AuditKey )  VALUES(  'ZW','ZWE',716,'Zimbabwe',2390,'A',1)

go

update dbo.Country set CountryDesc =  CountryName;
go
select * from dbo.country;

Pages

Tuesday, April 5, 2016

Country Code Dimension or Lookup Table

No comments: