世界各个国家中英文sql建表

DROP TABLE sp_countries
CREATE TABLE sp_countries(
   id INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
   zh_name NVARCHAR(100) NULL,
   en_name NVARCHAR(100) NULL,
   code NVARCHAR(50) NULL,
   parent_code INT NULL
)

SELECT * FROM sp_countries

INSERT INTO sp_countries (zh_name, code) VALUES
('阿尔巴尼亚', 'ALB'),
('阿尔及利亚', 'DZA'),
('阿富汗', 'AFG'),
('阿根廷', 'ARG'),
('阿拉伯联合酋长国', 'ARE'),
('阿鲁巴', 'ABW'),
('阿曼', 'OMN'),
('阿塞拜疆', 'AZE'),
('阿森松岛', 'ASC'),
('埃及', 'EGY'),
('埃塞俄比亚', 'ETH'),
('爱尔兰', 'IRL'),
('爱沙尼亚', 'EST'),
('安道尔', 'AND'),
('安哥拉', 'AGO'),
('安圭拉', 'AIA'),
('安提瓜岛和巴布达', 'ATG'),
('奥地利', 'AUT'),
('奥兰群岛', 'ALA'),
('澳大利亚', 'AUS'),
('巴巴多斯岛', 'BRB'),
('巴布亚新几内亚', 'PNG'),
('巴哈马', 'BHS'),
('巴基斯坦', 'PAK'),
('巴拉圭', 'PRY'),
('巴勒斯坦', 'PSE'),
('巴林', 'BHR'),
('巴拿马', 'PAN'),
('巴西', 'BRA'),
('白俄罗斯', 'BLR'),
('百慕大', 'BMU'),
('保加利亚', 'BGR'),
('北马里亚纳群岛', 'MNP'),
('贝宁', 'BEN'),
('比利时', 'BEL'),
('冰岛', 'ISL'),
('波多黎各', 'PRI'),
('波兰', 'POL'),
('波斯尼亚和黑塞哥维那', 'BIH'),
('玻利维亚', 'BOL'),
('伯利兹', 'BLZ'),
('博茨瓦纳', 'BWA'),
('不丹', 'BTN'),
('布基纳法索', 'BFA'),
('布隆迪', 'BDI'),
('布韦岛', 'BVT'),
('朝鲜', 'PRK'),
('丹麦', 'DNK'),
('德国', 'DEU'),
('东帝汶', 'TLS'),
('多哥', 'TGO'),
('多米尼加', 'DMA'),
('多米尼加共和国', 'DOM'),
('俄罗斯', 'RUS'),
('厄瓜多尔', 'ECU'),
('厄立特里亚', 'ERI'),
('法国', 'FRA'),
('法罗群岛', 'FRO'),
('法属波利尼西亚', 'PYF'),
('法属圭亚那', 'GUF'),
('法属南部领地', 'ATF'),
('梵蒂冈', 'VAT'),
('菲律宾', 'PHL'),
('斐济', 'FJI'),
('芬兰', 'FIN'),
('佛得角', 'CPV'),
('弗兰克群岛', 'FLK'),
('冈比亚', 'GMB'),
('刚果', 'COG'),
('刚果民主共和国', 'COD'),
('哥伦比亚', 'COL'),
('哥斯达黎加', 'CRI'),
('格恩西岛', 'GGY'),
('格林纳达', 'GRD'),
('格陵兰', 'GRL'),
('古巴', 'CUB'),
('瓜德罗普', 'GLP'),
('关岛', 'GUM'),
('圭亚那', 'GUY'),
('哈萨克斯坦', 'KAZ'),
('海地', 'HTI'),
('韩国', 'KOR'),
('荷兰', 'NLD'),
('荷属安地列斯', 'ANT'),
('赫德和麦克唐纳群岛', 'HMD'),
('洪都拉斯', 'HND'),
('基里巴斯', 'KIR'),
('吉布提', 'DJI'),
('吉尔吉斯斯坦', 'KGZ'),
('几内亚', 'GIN'),
('几内亚比绍', 'GNB'),
('加拿大', 'CAN'),
('加纳', 'GHA'),
('加蓬', 'GAB'),
('柬埔寨', 'KHM'),
('捷克共和国', 'CZE'),
('津巴布韦', 'ZWE'),
('喀麦隆', 'CMR'),
( '卡塔尔', 'QAT'),
( '开曼群岛', 'CYM'),
( '科科斯群岛', 'CCK'),
( '科摩罗', 'COM'),
( '科特迪瓦', 'CIV'),
( '科威特', 'KWT'),
( '克罗地亚', 'HRV'),
( '肯尼亚', 'KEN'),
( '库克群岛', 'COK'),
( '拉脱维亚', 'LVA'),
( '莱索托', 'LSO'),
( '老挝', 'LAO'),
( '黎巴嫩', 'LBN'),
( '立陶宛', 'LTU'),
( '利比里亚', 'LBR'),
( '利比亚', 'LBY'),
( '列支敦士登', 'LIE'),
( '留尼旺岛', 'REU'),
( '卢森堡', 'LUX'),
( '卢旺达', 'RWA'),
( '罗马尼亚', 'ROU'),
( '马达加斯加', 'MDG'),
( '马尔代夫', 'MDV'),
( '马耳他', 'MLT'),
( '马拉维', 'MWI'),
( '马来西亚', 'MYS'),
( '马里', 'MLI'),
( '马其顿', 'MKD'),
( '马绍尔群岛', 'MHL'),
( '马提尼克', 'MTQ'),
( '马约特岛', 'MYT'),
( '曼岛', 'IMN'),
( '毛里求斯', 'MUS'),
( '毛里塔尼亚', 'MRT'),
( '美国', 'USA'),
( '美属萨摩亚', 'ASM'),
( '美属外岛', 'UMI'),
( '蒙古', 'MNG'),
( '蒙特塞拉特', 'MSR'),
( '孟加拉', 'BGD'),
( '秘鲁', 'PER'),
( '密克罗尼西亚', 'FSM'),
( '缅甸', 'MMR'),
( '摩尔多瓦', 'MDA'),
( '摩洛哥', 'MAR'),
( '摩纳哥', 'MCO'),
( '莫桑比克', 'MOZ'),
( '墨西哥', 'MEX'),
( '纳米比亚', 'NAM'),
( '南非', 'ZAF'),
( '南极洲', 'ATA'),
( '南乔治亚和南桑德威奇群岛', 'SGS'),
( '瑙鲁', 'NRU'),
( '尼泊尔', 'NPL'),
( '尼加拉瓜', 'NIC'),
( '尼日尔', 'NER'),
( '尼日利亚', 'NGA'),
( '纽埃', 'NIU'),
( '挪威', 'NOR'),
( '诺福克', 'NFK'),
( '帕劳群岛', 'PLW'),
( '皮特凯恩', 'PCN'),
( '葡萄牙', 'PRT'),
( '乔治亚', 'GEO'),
( '日本', 'JPN'),
( '瑞典', 'SWE'),
( '瑞士', 'CHE'),
( '萨尔瓦多', 'SLV'),
( '萨摩亚', 'WSM'),
( '塞尔维亚,黑山', 'SCG'),
( '塞拉利昂', 'SLE'),
( '塞内加尔', 'SEN'),
( '塞浦路斯', 'CYP'),
( '塞舌尔', 'SYC'),
( '沙特阿拉伯', 'SAU'),
( '圣诞岛', 'CXR'),
( '圣多美和普林西比', 'STP'),
( '圣赫勒拿', 'SHN'),
( '圣基茨和尼维斯', 'KNA'),
( '圣卢西亚', 'LCA'),
( '圣马力诺', 'SMR'),
( '圣皮埃尔和米克隆群岛', 'SPM'),
( '圣文森特和格林纳丁斯', 'VCT'),
( '斯里兰卡', 'LKA'),
( '斯洛伐克', 'SVK'),
( '斯洛文尼亚', 'SVN'),
( '斯瓦尔巴和扬马廷', 'SJM'),
( '斯威士兰', 'SWZ'),
( '苏丹', 'SDN'),
( '苏里南', 'SUR'),
( '所罗门群岛', 'SLB'),
( '索马里', 'SOM'),
( '塔吉克斯坦', 'TJK'),
( '泰国', 'THA'),
( '坦桑尼亚', 'TZA'),
( '汤加', 'TON'),
( '特克斯和凯克特斯群岛', 'TCA'),
( '特里斯坦达昆哈', 'TAA'),
( '特立尼达和多巴哥', 'TTO'),
( '突尼斯', 'TUN'),
( '图瓦卢', 'TUV'),
( '土耳其', 'TUR'),
( '土库曼斯坦', 'TKM'),
( '托克劳', 'TKL'),
( '瓦利斯和福图纳', 'WLF'),
( '瓦努阿图', 'VUT'),
( '危地马拉', 'GTM'),
( '维尔京群岛，美属', 'VIR'),
( '维尔京群岛，英属', 'VGB'),
( '委内瑞拉', 'VEN'),
( '文莱', 'BRN'),
( '乌干达', 'UGA'),
( '乌克兰', 'UKR'),
( '乌拉圭', 'URY'),
( '乌兹别克斯坦', 'UZB'),
( '西班牙', 'ESP'),
( '希腊', 'GRC'),
( '新加坡', 'SGP'),
( '新喀里多尼亚', 'NCL'),
( '新西兰', 'NZL'),
( '匈牙利', 'HUN'),
( '叙利亚', 'SYR'),
( '牙买加', 'JAM'),
( '亚美尼亚', 'ARM'),
( '也门', 'YEM'),
( '伊拉克', 'IRQ'),
( '伊朗', 'IRN'),
( '以色列', 'ISR'),
( '意大利', 'ITA'),
( '印度', 'IND'),
( '印度尼西亚', 'IDN'),
( '英国', 'GBR'),
( '英属印度洋领地', 'IOT'),
( '约旦', 'JOR'),
( '越南', 'VNM'),
( '赞比亚', 'ZMB'),
( '泽西岛', 'JEY'),
( '乍得', 'TCD'),
( '直布罗陀', 'GIB'),
( '智利', 'CHL'),
('中国', 'PRC'),
( '中非共和国', 'CAF');

View Code

USE [Standard_RichData3]
GO
/****** Object:  Table [dbo].[sp_countries]    Script Date: 08/31/2017 11:46:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sp_countries](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [zh_name] [nvarchar](300) NULL,
    [en_name] [nvarchar](300) NULL,
    [code] [nvarchar](300) NULL,
    [parent_code] [int] NULL,
 CONSTRAINT [PK__sp_count__3213E83F123F82FA] 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]
GO
SET IDENTITY_INSERT [dbo].[sp_countries] ON
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (1, N'阿尔巴尼亚', N'Albania', N'ALB', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (2, N'阿尔及利亚', N'Algeria', N'DZA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (3, N'阿富汗', N'Afghanistan', N'AFG', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (4, N'阿根廷', N'Argentina', N'ARG', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (5, N'阿拉伯联合酋长国', N'The United Arab Emirates', N'ARE', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (6, N'阿鲁巴', N'Aruba', N'ABW', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (7, N'阿曼', N'Oman', N'OMN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (8, N'阿塞拜疆', N'Azerbaijan', N'AZE', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (9, N'阿森松岛', N'Ascension', N'ASC', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (10, N'埃及', N'Egypt', N'EGY', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (11, N'埃塞俄比亚', N'Ethiopia', N'ETH', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (12, N'爱尔兰', N'Ireland', N'IRL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (13, N'爱沙尼亚', N'Estonia', N'EST', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (14, N'安道尔', N'Andorra', N'AND', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (15, N'安哥拉', N'Angola', N'AGO', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (16, N'安圭拉', N'Anguilla', N'AIA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (17, N'安提瓜岛和巴布达', N'Antigua and Barbuda', N'ATG', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (18, N'奥地利', N'Austria', N'AUT', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (19, N'奥兰群岛', N'Oran Islands', N'ALA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (20, N'澳大利亚', N'Australia', N'AUS', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (21, N'巴巴多斯岛', N'Barbados', N'BRB', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (22, N'巴布亚新几内亚', N'papua new guinea', N'PNG', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (23, N'巴哈马', N'Bahamas', N'BHS', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (24, N'巴基斯坦', N'Pakistan', N'PAK', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (25, N'巴拉圭', N'Paraguay', N'PRY', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (26, N'巴勒斯坦', N'Palestine', N'PSE', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (27, N'巴林', N'Bahrain', N'BHR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (28, N'巴拿马', N'Panama', N'PAN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (29, N'巴西', N'Brazil', N'BRA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (30, N'白俄罗斯', N'Belarus', N'BLR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (31, N'百慕大', N'Bermuda', N'BMU', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (32, N'保加利亚', N'Bulgaria', N'BGR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (33, N'北马里亚纳群岛', N'Northern Mariana Islands', N'MNP', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (34, N'贝宁', N'Benin', N'BEN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (35, N'比利时', N'Belgium', N'BEL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (36, N'冰岛', N'Iceland', N'ISL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (37, N'波多黎各', N'Puerto Rico', N'PRI', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (38, N'波兰', N'poland', N'POL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (39, N'波斯尼亚和黑塞哥维那', N'Bosnia and Herzegovina', N'BIH', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (40, N'玻利维亚', N'bolivia', N'BOL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (41, N'伯利兹', N'Belize', N'BLZ', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (42, N'博茨瓦纳', N'botswana', N'BWA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (43, N'不丹', N'Bhutan', N'BTN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (44, N'布基纳法索', N'burkina faso', N'BFA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (45, N'布隆迪', N'burundi', N'BDI', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (46, N'布韦岛', N'Bouvet Island', N'BVT', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (47, N'朝鲜', N'North Korea', N'PRK', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (48, N'丹麦', N'Denmark', N'DNK', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (49, N'德国', N'Germany', N'DEU', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (50, N'东帝汶', N'Timor-Leste', N'TLS', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (51, N'多哥', N'Togo', N'TGO', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (52, N'多米尼加', N'Dominican', N'DMA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (53, N'多米尼加共和国', N'Dominican Republic', N'DOM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (54, N'俄罗斯', N'Russia', N'RUS', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (55, N'厄瓜多尔', N'Ecuador', N'ECU', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (56, N'厄立特里亚', N'Eritrea', N'ERI', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (57, N'法国', N'France', N'FRA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (58, N'法罗群岛', N'Faroe Islands', N'FRO', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (59, N'法属波利尼西亚', N'French Polynesia', N'PYF', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (60, N'法属圭亚那', N'French Guiana', N'GUF', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (61, N'法属南部领地', N'French Southern Territories', N'ATF', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (62, N'梵蒂冈', N'Vatican', N'VAT', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (63, N'菲律宾', N'The Philippines', N'PHL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (64, N'斐济', N'Fiji', N'FJI', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (65, N'芬兰', N'Finland', N'FIN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (66, N'佛得角', N'Cape Verde', N'CPV', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (67, N'弗兰克群岛', N'Frank Islands', N'FLK', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (68, N'冈比亚', N'Gambia', N'GMB', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (69, N'刚果', N'Congo', N'COG', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (70, N'刚果民主共和国', N'Democratic Republic of Congo', N'COD', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (71, N'哥伦比亚', N'Columbia', N'COL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (72, N'哥斯达黎加', N'Costa Rica', N'CRI', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (73, N'格恩西岛', N'guernsey', N'GGY', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (74, N'格林纳达', N'Grenada', N'GRD', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (75, N'格陵兰', N'Greenland', N'GRL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (76, N'古巴', N'Cuba', N'CUB', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (77, N'瓜德罗普', N'Gua de Ropp', N'GLP', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (78, N'关岛', N'Guam', N'GUM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (79, N'圭亚那', N'Guyana', N'GUY', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (80, N'哈萨克斯坦', N'Kazakhstan', N'KAZ', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (81, N'海地', N'Haiti', N'HTI', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (82, N'韩国', N'The Republic of Korea', N'KOR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (83, N'荷兰', N'Netherlands', N'NLD', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (84, N'荷属安地列斯', N'netherlands antilles', N'ANT', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (85, N'赫德和麦克唐纳群岛', N'Heard And Mcdonald Islands', N'HMD', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (86, N'洪都拉斯', N'Honduras', N'HND', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (87, N'基里巴斯', N'Kiribati', N'KIR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (88, N'吉布提', N'Djibouti', N'DJI', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (89, N'吉尔吉斯斯坦', N'Kyrgyzstan', N'KGZ', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (90, N'几内亚', N'Guinea', N'GIN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (91, N'几内亚比绍', N'Guinea-Bissau', N'GNB', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (92, N'加拿大', N'Canada', N'CAN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (93, N'加纳', N'Ghana', N'GHA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (94, N'加蓬', N'Gabon', N'GAB', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (95, N'柬埔寨', N'Cambodia', N'KHM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (96, N'捷克共和国', N'Czech Republic', N'CZE', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (97, N'津巴布韦', N'zimbabwe', N'ZWE', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (98, N'喀麦隆', N'Cameroon', N'CMR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (99, N'卡塔尔', N'Qatar', N'QAT', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (100, N'开曼群岛', N'Cayman Islands', N'CYM', NULL)
GO
print 'Processed 100 total records'
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (101, N'科科斯群岛', N'Cocos Islands', N'CCK', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (102, N'科摩罗', N'Comoros', N'COM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (103, N'科特迪瓦', N'Cote d''Ivoire', N'CIV', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (104, N'科威特', N'Kuwait', N'KWT', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (105, N'克罗地亚', N'Croatia', N'HRV', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (106, N'肯尼亚', N'Kenya', N'KEN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (107, N'库克群岛', N'Cook Islands', N'COK', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (108, N'拉脱维亚', N'Latvia', N'LVA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (109, N'莱索托', N'Lesotho', N'LSO', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (110, N'老挝', N'Laos', N'LAO', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (111, N'黎巴嫩', N'Lebanon', N'LBN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (112, N'立陶宛', N'Lithuania', N'LTU', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (113, N'利比里亚', N'Liberia', N'LBR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (114, N'利比亚', N'Libya', N'LBY', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (115, N'列支敦士登', N'Liechtenstein', N'LIE', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (116, N'留尼旺岛', N'Reunion', N'REU', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (117, N'卢森堡', N'Luxembourg', N'LUX', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (118, N'卢旺达', N'Rwanda', N'RWA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (119, N'罗马尼亚', N'Romania', N'ROU', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (120, N'马达加斯加', N'Madagascar', N'MDG', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (121, N'马尔代夫', N'Maldives', N'MDV', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (122, N'马耳他', N'Malta', N'MLT', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (123, N'马拉维', N'Malawi', N'MWI', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (124, N'马来西亚', N'Malaysia', N'MYS', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (125, N'马里', N'Mali', N'MLI', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (126, N'马其顿', N'Macedonia', N'MKD', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (127, N'马绍尔群岛', N'Marshall Islands', N'MHL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (128, N'马提尼克', N'Martinique', N'MTQ', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (129, N'马约特岛', N'Mayotte', N'MYT', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (130, N'曼岛', N'The Isle of man', N'IMN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (131, N'毛里求斯', N'Mauritius', N'MUS', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (132, N'毛里塔尼亚', N'Mauritania', N'MRT', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (133, N'美国', N'U.S.A', N'USA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (134, N'美属萨摩亚', N'American Samoa', N'ASM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (135, N'美属外岛', N'The outlying islands', N'UMI', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (136, N'蒙古', N'Mongolia', N'MNG', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (137, N'蒙特塞拉特', N'Montserrat', N'MSR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (138, N'孟加拉', N'Bengal', N'BGD', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (139, N'秘鲁', N'Peru', N'PER', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (140, N'密克罗尼西亚', N'Micronesia', N'FSM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (141, N'缅甸', N'Myanmar', N'MMR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (142, N'摩尔多瓦', N'Moldova', N'MDA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (143, N'摩洛哥', N'Morocco', N'MAR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (144, N'摩纳哥', N'Monaco', N'MCO', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (145, N'莫桑比克', N'Mozambique', N'MOZ', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (146, N'墨西哥', N'Mexico', N'MEX', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (147, N'纳米比亚', N'Namibia', N'NAM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (148, N'南非', N'South Africa', N'ZAF', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (149, N'南极洲', N'Antarctica', N'ATA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (150, N'南乔治亚和南桑德威奇群岛', N'South Georgia and the South Sandwich Islands', N'SGS', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (151, N'瑙鲁', N'Nauru', N'NRU', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (152, N'尼泊尔', N'Nepal', N'NPL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (153, N'尼加拉瓜', N'Nicaragua', N'NIC', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (154, N'尼日尔', N'Niger', N'NER', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (155, N'尼日利亚', N'Nigeria', N'NGA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (156, N'纽埃', N'Niue', N'NIU', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (157, N'挪威', N'Norway', N'NOR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (158, N'诺福克', N'Norfolk', N'NFK', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (159, N'帕劳群岛', N'Palau', N'PLW', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (160, N'皮特凯恩', N'Pitcairn', N'PCN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (161, N'葡萄牙', N'Portugal', N'PRT', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (162, N'乔治亚', N'Georgia', N'GEO', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (163, N'日本', N'Japan', N'JPN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (164, N'瑞典', N'Sweden', N'SWE', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (165, N'瑞士', N'Switzerland', N'CHE', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (166, N'萨尔瓦多', N'Salvatore', N'SLV', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (167, N'萨摩亚', N'Samoa', N'WSM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (168, N'塞尔维亚,黑山', N'Montenegro, Serbia', N'SCG', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (169, N'塞拉利昂', N'sierra leone', N'SLE', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (170, N'塞内加尔', N'Senegal', N'SEN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (171, N'塞浦路斯', N'Cyprus', N'CYP', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (172, N'塞舌尔', N'Seychelles', N'SYC', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (173, N'沙特阿拉伯', N'Saudi Arabia', N'SAU', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (174, N'圣诞岛', N'Christmas Island', N'CXR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (175, N'圣多美和普林西比', N'Sao Tome and Principe', N'STP', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (176, N'圣赫勒拿', N'Helena', N'SHN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (177, N'圣基茨和尼维斯', N'Saint Kitts and Nevis', N'KNA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (178, N'圣卢西亚', N'Saint Lucia', N'LCA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (179, N'圣马力诺', N'San Marino', N'SMR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (180, N'圣皮埃尔和米克隆群岛', N'San Pierre and M Islands', N'SPM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (181, N'圣文森特和格林纳丁斯', N'Saint Vincent and the Grenadines', N'VCT', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (182, N'斯里兰卡', N'Sri Lanka', N'LKA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (183, N'斯洛伐克', N'Slovakia', N'SVK', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (184, N'斯洛文尼亚', N'Slovenia', N'SVN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (185, N'斯瓦尔巴和扬马廷', N'J Val Ba and Yang Ting Ting', N'SJM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (186, N'斯威士兰', N'Swaziland', N'SWZ', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (187, N'苏丹', N'Sultan', N'SDN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (188, N'苏里南', N'Suriname', N'SUR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (189, N'所罗门群岛', N'Solomon Islands', N'SLB', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (190, N'索马里', N'Somalia', N'SOM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (191, N'塔吉克斯坦', N'Tajikistan', N'TJK', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (192, N'泰国', N'Thailand', N'THA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (193, N'坦桑尼亚', N'Tanzania', N'TZA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (194, N'汤加', N'Tonga', N'TON', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (195, N'特克斯和凯克特斯群岛', N'The Turks and Kaiketesi Islands', N'TCA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (196, N'特里斯坦达昆哈', N'Tristan Da khuon ha', N'TAA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (197, N'特立尼达和多巴哥', N'Trinidad and Tobago', N'TTO', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (198, N'突尼斯', N'Tunisia', N'TUN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (199, N'图瓦卢', N'Tuvalu', N'TUV', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (200, N'土耳其', N'Turkey', N'TUR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (201, N'土库曼斯坦', N'Turkmenistan', N'TKM', NULL)
GO
print 'Processed 200 total records'
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (202, N'托克劳', N'Tokelau', N'TKL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (203, N'瓦利斯和福图纳', N'Wallis and Futuna', N'WLF', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (204, N'瓦努阿图', N'Vanuatu', N'VUT', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (205, N'危地马拉', N'Guatemala', N'GTM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (206, N'维尔京群岛，美属', N'Virgin Islands, American', N'VIR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (207, N'维尔京群岛，英属', N'Virgin Islands, British', N'VGB', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (208, N'委内瑞拉', N'Venezuela', N'VEN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (209, N'文莱', N'Brunei', N'BRN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (210, N'乌干达', N'Uganda', N'UGA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (211, N'乌克兰', N'Ukraine', N'UKR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (212, N'乌拉圭', N'Uruguay', N'URY', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (213, N'乌兹别克斯坦', N'Uzbekistan', N'UZB', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (214, N'西班牙', N'Spain', N'ESP', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (215, N'希腊', N'Greece', N'GRC', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (216, N'新加坡', N'Singapore', N'SGP', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (217, N'新喀里多尼亚', N'New Caledonia', N'NCL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (218, N'新西兰', N'New Zealand', N'NZL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (219, N'匈牙利', N'Hungary', N'HUN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (220, N'叙利亚', N'Syria', N'SYR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (221, N'牙买加', N'Jamaica', N'JAM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (222, N'亚美尼亚', N'Armenia', N'ARM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (223, N'也门', N'Yemen', N'YEM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (224, N'伊拉克', N'Iraq', N'IRQ', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (225, N'伊朗', N'Iran', N'IRN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (226, N'以色列', N'Israel', N'ISR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (227, N'意大利', N'Italy', N'ITA', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (228, N'印度', N'India', N'IND', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (229, N'印度尼西亚', N'Indonesia', N'IDN', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (230, N'英国', N'Britain', N'GBR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (231, N'英属印度洋领地', N'British India Ocean Territory', N'IOT', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (232, N'约旦', N'Jordan', N'JOR', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (233, N'越南', N'Vietnam', N'VNM', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (234, N'赞比亚', N'Zambia', N'ZMB', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (235, N'泽西岛', N'Jersey', N'JEY', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (236, N'乍得', N'Chad', N'TCD', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (237, N'直布罗陀', N'Gibraltar', N'GIB', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (238, N'智利', N'Chile', N'CHL', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (239, N'中国', N'China', N'PRC', NULL)
INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (240, N'中非共和国', N'Central African Republic', N'CAF', NULL)
SET IDENTITY_INSERT [dbo].[sp_countries] OFF

View Code

posted @ 2017-08-31 11:21 SmilePastaLi 阅读(1790) 评论(0) 编辑收藏举报

刷新页面返回顶部

登录后才能查看或发表评论，立即登录或者逛逛博客园首页

SmilePastaLi

世界各个国家中英文sql建表

公告

搜索

积分与排名

随笔分类

阅读排行榜

评论排行榜

推荐排行榜

最新评论